Worbook increases in size, slows down too much

[Alexander]

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?

 

[Niek Otten]

Hi Alexander,

Check this:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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?
|
|

 

[XP]

Just a thought...
Do you use querytables? If so, you may need to delete these invisible
objects and their associated range names that are invisibly added to the
sheet every time they are run.

 

[Alexander]

Thanks for the thought.

What's a querytable?

How would I find out if I (unintentionally) added one?

 

[Alexander]

Thanks for the suggestion.

The ends of each of the spreadsheets are where they're supposed to be.

Alexander