Simple worksheet becomes large and slow

I use 2 simple worksheets daily. They contain little data and should be less
than 50k. I change them by copying data from various other spreadsheets into
them, then saving or saving as with a new name. Some of these spreadsheets
for some reason become very large (1.5mb or more) and moving from cell to
cell becomes very slow. Copying from those spreadsheets to new sheets can
take up to 30 seconds for a single cell to copy. There is nothing complex in
any of them, just text, some multiplication and sum. The sheets eventually
become so slow that the only way I can work with them is by copying the data
i need into new clean sheets. i do this by using the copy, past special and
values - hoping not to copy over whatever is bogging down the original
spreadsheet. Anyone ever see this? Any idea how to fix it?

does your row all of a sudden go to thousands of rows? copying and pasting into a new worksheet will help, but make sure that there are no macros or other functions that cause the worksheet to have so many rows.

Press Ctrl + End and see where it goes, if it goes beyond the last data, then
that can be part of the problem, select the first empty cell below the last
data, press Ctrl + down arrow, do edit>delete, do the same for the last
columns to the right but press Ctrl + right arrow, delete, save workbook

regards,

Peo Sjoblom

"Judy" wrote:

> I use 2 simple worksheets daily. They contain little data and should be less
> than 50k. I change them by copying data from various other spreadsheets into
> them, then saving or saving as with a new name. Some of these spreadsheets
> for some reason become very large (1.5mb or more) and moving from cell to
> cell becomes very slow. Copying from those spreadsheets to new sheets can
> take up to 30 seconds for a single cell to copy. There is nothing complex in
> any of them, just text, some multiplication and sum. The sheets eventually
> become so slow that the only way I can work with them is by copying the data
> i need into new clean sheets. i do this by using the copy, past special and
> values - hoping not to copy over whatever is bogging down the original
> spreadsheet. Anyone ever see this? Any idea how to fix it?

Judy

Where does CTRL + END take?

If far below and right of your "real" data, check out Debra Dalgleish's site
for instructions on resetting the used range.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben Excel MVP

On Tue, 10 May 2005 11:02:01 -0700, "Judy" <Judy@discussions.microsoft.com>
wrote:

>I use 2 simple worksheets daily. They contain little data and should be less
>than 50k. I change them by copying data from various other spreadsheets into
>them, then saving or saving as with a new name. Some of these spreadsheets
>for some reason become very large (1.5mb or more) and moving from cell to
>cell becomes very slow. Copying from those spreadsheets to new sheets can
>take up to 30 seconds for a single cell to copy. There is nothing complex in
>any of them, just text, some multiplication and sum. The sheets eventually
>become so slow that the only way I can work with them is by copying the data
>i need into new clean sheets. i do this by using the copy, past special and
>values - hoping not to copy over whatever is bogging down the original
>spreadsheet. Anyone ever see this? Any idea how to fix it?

when you copy the data into the worksheet. Do you paste special values, just
paste or insert copied cells?

when you copy the data in the other sheets. do you select a given range or
the whole row or column?

"Judy" wrote:

> I use 2 simple worksheets daily. They contain little data and should be less
> than 50k. I change them by copying data from various other spreadsheets into
> them, then saving or saving as with a new name. Some of these spreadsheets
> for some reason become very large (1.5mb or more) and moving from cell to
> cell becomes very slow. Copying from those spreadsheets to new sheets can
> take up to 30 seconds for a single cell to copy. There is nothing complex in
> any of them, just text, some multiplication and sum. The sheets eventually
> become so slow that the only way I can work with them is by copying the data
> i need into new clean sheets. i do this by using the copy, past special and
> values - hoping not to copy over whatever is bogging down the original
> spreadsheet. Anyone ever see this? Any idea how to fix it?