Worbook increases in size, slows down too much
 

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?

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

Worbook increases in size, slows down too much
 

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" wrote:

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?

Worbook increases in size, slows down too much
 

Thanks for the thought.

What's a querytable?

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

"XP" wrote in message
...

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" wrote:

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?

Worbook increases in size, slows down too much
 

Thanks for the suggestion.

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

Alexander

"Niek Otten" wrote in message
...
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?
|
|