Why is xlsx version slow to open

J

JPierce

Using Excel 2007 if I open a 97-2003 verison of a file it loads in
about 1 second. If I open a (converted) xlsx version of the same file
it takes about 5 seconds. Also it is larger than the orignal. I
thought 2007 files were supposed to be smaller than 2003 files?

Any idea as to why this might be?

Thanks,
JPierce
 
C

Charles Williams

xlsb files are usually faster to open than xlsx files.

(XLSX files are compressed XML, XLSB are compressed binary which is more
like the old .xls)


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
J

JPierce

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,
 
C

Charles Williams

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top