View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Excel Sheet Suddenly Runs Slow

It is hard to comment on the specifics without seeing exactly what you are up
to. That being sid check out the following link:

http://www.decisionmodels.com/index.htm

look at Calculation, Optomizing Speed and Memory.
--
HTH...

Jim Thomlinson


"Ed O'Brien" wrote:

PC = Dell Dimension... 4GB RAM Intel Duo core 6700 @ 2.66GHz 2.67GHz.
(Plenty for this job)!

Excel 2007 - Vista Home Premium

I have an Excel workbook for personal accounts. It has several sheets:
Current Account, Credit Cards, Statements, Income Tax....

Suddenly the Current Account sheet - which has much more info and formulae -
has suddenly started to run incredibly slow. It took 37 seconds to paste
just two small entries.

As the page loads, it can be seen to hesitate as it loads. The same when
scrolling the page. It behaves as though it is moving megabites of info yet
the total file size for the workbook is only 218KB.

Has anyone experienced this and can anyone help with a cure?

TIA for any input.

Ed