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

Toad Data Point
1

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.

2

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

3

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

4

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

5

Same problem that's posted using Office 365 64-bit through employer (top 10 bank). Just got upgrade to v5, all prior versions worked fine