After an error, automation no longer shows Excel sheets

Toad Data Point
1

Version 3.0 - I need this version because of other errors in future versions so far.

I was adding an export to Excel step and had an error that caused Toad to freeze. After re-opening Toad, when trying to create an Automation script that exports data into Excel, it no longer allows me to select a sheet - the area where the sheets are shown are greyed and cannot be selected.

I re-installed the PIA from Microsoft. Any other ideas to allow me to create an export to Excel step i automation?

Thanks,

Pete

2

The only time the are in export to excel would display the sheets would be if you are pointing to an existing file AND you do not have Overwrite selected. Check those options.

I would like more info on this–>“Version 3.0 - I need this version because of other errors in future versions so far.” What errors?