I'm writing an application that will load an existing template spreadsheet, populate a large amount of data on a single worksheet, and then save the file under a new name.
If I write the data without first opening a spreadsheet, it works fine.
If I first open an existing simple spreadsheet (only the word text in one cell), it completes,but there is garbage data on each worksheet of the output spreadsheet.
If I first open the actual template spreadsheet (4.4MB) it locks up during the save to the new file.
I am testing with the evaluation version if this makes a difference.