View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Excel Sheet Suddenly Runs Slow

I suggest reading this page;
http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm\



--
Regards
Dave Hawley
www.ozgrid.com
"Ed O'Brien" wrote in message
...
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