Trouble opening a 4MB + workbook after creating it through Aspose.Excel


#1

During our evaluation, I have successfully been able to create thousands of workbooks very quickly and with stable results. A couple of these workbooks, from what I can see they are 4-5MB is size, do not open properly in Excel. When I try to open them, Excel quickly flashes the loading progress bar on the bottom of the window, then displays the default Sheet tabs as if I am just opening Excel with no workbook. Our current processing of the same data is able to produce a working file with all of the data in it - so I don’t think we are hitting an Excel limit. Anything less then 4MB seems to open fine. Is there something we can check?


#2

Which version are your using? The latest version is v2.3.3. Please download it and have a try.

If problem still exists, could you zip and email your file with above problem? Or please give me a download link if the file is too big.


#3

Laurence,

I have the filed zipped - where can I send it to?

Bob


#4

Please send email to excel@nospam.aspose.com.


#5

Hi Laurence…have you discovered why the 4MB+ file I sent doesn’t open properly in Excel? Was the other sample (smaller) file helpful?


#6

I think this problem is caused by too many worksheets - in your large file there are more than 1500 worksheets. I will check and fix it.


#7

Yes, this workbook has more than 1500 worksheets in it.

When you fix this, what will the new limit be on the number of worksheets? Excel does not have a limit, as far as it’s documentation says (as long as there is memory available).

Thank you for looking into this - our evaluation is complete pending a test of the fix.


#8

I have fixed this problem and there will be no limit on the number of worksheets. You will get this fix tomorrow.


#9

Please download the latest hotfix and have a try.


#10

Laurence,

Just downloaded the hotfix and tested it - the new workbook opened with no problem. Thank you for the very quick turn-around on this issue. We are going with your product for our project!

Bob