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