When doing an Export Dataset activity to an Excel Instance, the following error is received:
"Toad Message Unexpected error: invalid variant operation. If you have multiple Excel files open, retry with zero or one open Excel file. If the active cell is in edit mode, go to Excel and press Esc or Enter to leave edit mode."
The error occurs when using Toad 64 bit and Office 32 bit.
WORKAROUND:
Download and install Office 64 bit.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center