tobal99z
asked on
excel 2010 slow to open file
Hello All,
I ugraded to Office 2010 today, from Office 2003.
I'm having a problem with Excel 2010.
One of my files (from Excel 2003, ".xls") opens at an acceptable speed in Excel 2010, say 15-25 seconds or so.
I then saved the file as ".xlsm" format. The save was pretty slow. When I try to open the newly saved file, it is really really slow to open, say 5-10 minutes.
This is driving me crazy. The file is about 7 megs. It has about 15 work sheets, lots of colors, formats, and some DDE links to Bloomberg. Does anyone have any ideas?
My guess is that this has to do with the DDE links with Bloomberg... but everything works fine in the .xls version... plus in smaller .xlsm files which i have.
(note: running in XP SP3 on pretty good hardware)
Thank you!
I ugraded to Office 2010 today, from Office 2003.
I'm having a problem with Excel 2010.
One of my files (from Excel 2003, ".xls") opens at an acceptable speed in Excel 2010, say 15-25 seconds or so.
I then saved the file as ".xlsm" format. The save was pretty slow. When I try to open the newly saved file, it is really really slow to open, say 5-10 minutes.
This is driving me crazy. The file is about 7 megs. It has about 15 work sheets, lots of colors, formats, and some DDE links to Bloomberg. Does anyone have any ideas?
My guess is that this has to do with the DDE links with Bloomberg... but everything works fine in the .xls version... plus in smaller .xlsm files which i have.
(note: running in XP SP3 on pretty good hardware)
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This article explains why opening .XLSM files is so slow but doesn't say how to cure it or open a file faster. I tried saving an .XLSM with SaveAs .XLS i.e. revert to previous version of Excel.
It creates a very significantly bigger file but it opens in seconds.
In a safe (closed?) environment, is there any justification for 2007/2010 formats when the old 2003 format out-performs it? ... or am I missing something?
It creates a very significantly bigger file but it opens in seconds.
In a safe (closed?) environment, is there any justification for 2007/2010 formats when the old 2003 format out-performs it? ... or am I missing something?
ASKER