Hi,
1 of our user file had bunch of pivot tables (in multiple worksheets) in this workbook and some standard dataset in worksheets and formula referring to other worksheets. I tried to import this excel file using
Workbook wbExceldata = Workbook.Load(fileName);
and it takes 3 to 4 min for executing the Load command for loading empty workbook with 1 blank sheet (I deleted all other worksheets).
Even after removing all worksheets still it is 600 KB. it seems to holding it in memory i guess.It works for other excel files and am guessing something weird in this workbook.
Can you please help me to figure out why this file takes long time to load.
Thanks,
Valliappan
Can you post the workbook which has no worksheets? I'm guessing that it still has worksheets, but they are just hidden.
Hi Dour,
Since the file is 500 KB even after winzip, i can't upload the file as 200 KB is the max upload limit. Can you please let me know hoe can i send the file?
There are no hidden sheets and otehr info i would like to share is after excel file was loaded , i did look at the excel object in teh debugger and it had named references count =72 even though i removed all pivots and worksheet references in the workbook and had a empty workbook.