ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems with Excel 2007 being slow? (https://www.excelbanter.com/excel-discussion-misc-queries/136127-problems-excel-2007-being-slow.html)

Jon M

Problems with Excel 2007 being slow?
 
I was having major speed issues with Excel 2007 on my PC (2.0Ghz Core 2 Duo,
2G RAM, XP Pro). Whenever I would save a .xlsx file down to an .xls file, or
try to work within some .xls files, EVERYTHING took a long time - cut/paste,
formatting, undo... it was ridiculous (and still is!). So, the secret? Open
up a brand new .xlsx file, copy the data from the .xls file (or slow .xlsx
file), and paste it in the new file. Presto! Things are much faster. Even
when I tried to save an .xls file as a .xlsx file, it was still slow, but
this fixed it.

Beware that if you try to save this as a .xls and work in that, it may slow
things down again.

ARE YOU LISTENING, MICROSOFT??

Dave F

Problems with Excel 2007 being slow?
 
When I use XL 2007 it's on a machine with the same configuration as yours,
except I have an AMD processor. I haven't noticed the kinds of performance
problems you indicate. Perhaps take a look at this white paper about XL 07
performance for ideas: http://msdn2.microsoft.com/en-us/library/aa730921.aspx
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jon M" wrote:

I was having major speed issues with Excel 2007 on my PC (2.0Ghz Core 2 Duo,
2G RAM, XP Pro). Whenever I would save a .xlsx file down to an .xls file, or
try to work within some .xls files, EVERYTHING took a long time - cut/paste,
formatting, undo... it was ridiculous (and still is!). So, the secret? Open
up a brand new .xlsx file, copy the data from the .xls file (or slow .xlsx
file), and paste it in the new file. Presto! Things are much faster. Even
when I tried to save an .xls file as a .xlsx file, it was still slow, but
this fixed it.

Beware that if you try to save this as a .xls and work in that, it may slow
things down again.

ARE YOU LISTENING, MICROSOFT??



All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com