VERY SLOW EXCEL 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have recently installed Excel 2007 Home & Student. Unfortunatley
everything seems to take 10X longer to do. Any suggestions as to what I can
do to speed this up. I have done everything I know to do on my system setup
ie Deleted unused programmes, defrag, disk clean up etc.

Many thanks

Gavin
 
Exactly what are you doing with your Excel files? If there are a lot of
shape objects such as charts and graphs, that will definitely slow things
down. I've also experienced noticeable slowdown in the handling of user
defined functions in 2007 as compared to how fast they ran under earlier
versions of Excel on a slower machine.

Also, what is the hardware configuration of your system: how much memory is
installed and what type processor (make/model) is in it?
 
Adding to Jerry's answer

If you don't have a dual core processor, turning off multi-threading ion
Excel options can help, also

Use the .xlsb format for speed.
If it is an upgrade check you have upgraded personal.xls to xlsx or xlsm is
it has code and book.xlt and sheet.xlt if you have them
Work wherever possible in the new format as the old ones in compatibility
mode are slow.
Check you have the latest updates for your virus scanner (Avoid norton if
possible)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 
the only suggestion i have is to go back to xl2003. i have simple code that runs
half as fast in vista/xl2007 than it does in xp/xl2003. i have not upgraded any
of my clients to either one of those, just too many issues.
 
Have you run the Microsoft Diagnostics Tool in the Office Tools Folder under
All Programs, Microsoft Office.

This may find a problem.
 
Hi, thanks for the help so far.

No shapes or graphs being used. Fairly large spread sheets with formulas &
macro's.

Processor
1.60 gigahertz AMD Athlon XP
128 kilobyte primary memory cache
256 kilobyte secondary memory cache

Hope this answers your questions.

Gavin
 
Gary Keramidas said:
the only suggestion i have is to go back to xl2003. i have simple code that runs
half as fast in vista/xl2007 than it does in xp/xl2003. i have not upgraded any
of my clients to either one of those, just too many issues.

Absolutely right. None of the fixes proposed on this site or any other have done anything to increase the speed of my workbook which admittedly has LOTS (and I mean L_O_T_S!) of macros.

Excel 2k7 is an inferior product designed for business-school types and utterly useless for engineering/scientific applications. Who the hell needs a ribbon with a dozen "style" buttons.
Click to expand...
 
Back
Top