presumably the file has been calculated by XL2007 before saving so that you
are avoiding the calculate on open.
You could try setting workbook.forceFullCalculate to True (do this in the
VBE, select the workbook in project explorer, press F4 to get Properties
....)
This will avoid rebuilding the dependency tree at open, but will probably
seriously slow down your recalculations.
Also update Excel 2007 to SP2 if you have not already done so (contains some
performance improvements)
Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
xlsbfilesare usually faster toopenthan xlsxfiles.
(XLSXfilesare compressed XML, XLSB are compressed binary which is more
like the old .xls)
Charles
___________________________________
The Excel Calculation Sitehttp://
www.decisionmodels.com
- Show quoted text -
Thank you. I converted the file to binary and it reduced the siize by
1/2 (36.5 Mb to 16.5 Mb) but it sill takes about 4 seconds to load
compared to only about 1 to 2 seconds for the 39 Mb 97-2003 version.
Are their setting that might impact this? I guess I will have to
figure out what format to work in based on the file size and
application. I was under the impression that the normal format for
2007 was xlsx? If that correct?
Thanks,