Toad World® Forums

Export to Excel instance - Object does not match target type. Export is cancelled

Ever since I upgraded to the most recent version of Data Point (5.2.1.299, 64 bit), I've been getting the error "Object does not match target type. Export is cancelled" when I try to export to an excel instance. I'm still able to export to an Excel file, but export to Excel instance fails in both the right-click menu and the export wizard.

Thanks for your help, and let me know if I can provide any other details.

I'll try it on our newest build. What version of Office have you got?

I've just tested it and on my Office 365 and latest TDP exporting to an Excel instance works fine.

I just went out and downloaded the newest Office update, and it's working now. Thanks for looking into it!