I have an export script that is causing an error. We have an excel file that we need to export data to, but also need to be able to save the file via excel. The export script works fine in two situations. 1) When no file exists. 2) When the file that exists has not been saved by excel. As soon as we save the file via excel the export results in this error. This is true even if no changes have been made to the file prior to saving it in excel. In addition to resulting in this error, the excel file becomes corrupted and unusable.
The following screenshot is the error received.
I have read through the following thread, but do not see a solution contained there.
I am running Toad for SQL Server v126.96.36.199 and Excel for Office 365 (Build 16.0.11126.20234)
Does anyone have a solution or workaround for this?
Thanks in advance for any help!