When exporting to a specified worksheet in an Excel spreadsheet WITH multiple worksheets I get ‘file corrupt’ when opening file. This only occurs when I write to an existing file that has other worksheets AND when I use variables to write to multiple files. If I write to a new file (one worksheet only) I get no errors, or if I update only 1 file with no variables I am ok.
Example: automation script with a sql statement gathering active salesperson numbers that feed a bind variable one salesperson at a time to generate their open data. This variable is used for generating the data for each salesperson and to name the file. The file is pre-setup with pivots which auto-refresh once opened and data is written to sheet1.
Maximum file size is under 3mb so I do not believe this is the previous file size error.
Has anyone had this issues? I get the same ‘file corrupt’ when I use TDA 3.1.