View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Ed O'Brien Ed O'Brien is offline
external usenet poster
 
Posts: 36
Default Excel Sheet Suddenly Runs Slow

Thanks, Jim. Problem resolved. Check my response to Michael.

Best ewishes,

Ed



"Jim Thomlinson" wrote in message
...
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