View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Worbook increases in size, slows down too much

Hi Alexander,

Check this:

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Alexander" wrote in message news:Zfp3j.24452$XT.12499@trnddc01...
| This workbook with a half dozen worksheets keeps my checking account info.
|
| The largest is the History sheet with 4100 rows, 9 columns, no calculation.
|
| Next is the Current sheet with 700 rows, 9 columns, numerous calculations
| including links to a "checks cleared" sheet .
|
| Up until a couple months ago this file increased by about 50K/mo; now it's
| increasing by 500K. I've made no significant increases in the rate at which
| I've added data.
|
| Just scrolling down in the Current sheet is slow and CPU use jumps to 50%.
|
| I get the same result even with auto-recalculation off.
|
| I've run the Error checking tool, and it didn't find anything.
|
| I've eliminated the History sheet with no significant change.
|
| What's going on?
|
|