Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Judy
 
Posts: n/a
Default 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?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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?

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


  #4   Report Post  
bj
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow workbook sac73 Excel Discussion (Misc queries) 1 April 21st 05 10:39 PM
Why is eveything so slow after upgrading from Excel 2000 to 2003? Spinner Excel Discussion (Misc queries) 12 April 10th 05 05:51 AM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 01:21 AM
Worksheet Running Very Slow Dmorri254 Excel Worksheet Functions 4 February 3rd 05 05:49 PM
Slow opening files - possible cause and solutoin Bob Flanagan Excel Discussion (Misc queries) 0 November 29th 04 11:04 PM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"