I am facing a problem while generating excel sheet in 2003 format. I am having a scenario where the workbook can contain multiple sheets. While opening the sheet it displays following problem :
"Some sheets could not be loaded because the maximum number of
sheets was exceeded."
Following is the finding on Excel Office documentation :
"Sheets in a workbook : Limited by available memory (default is 3 sheets)"
What would be the maximum number of sheets that an Excel(2003) can have with 2GB memory?
Well, there is no specific limit regarding Worksheets in the workbook. You can have as many sheets if you memory allows this. Could you create a sample console application with the template file(s) to show the issue, zip it and post it here, we will check it soon.
By the way which version you are using, did you try latest v4.8.2?