Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slow workbook | Excel Discussion (Misc queries) | |||
Why is eveything so slow after upgrading from Excel 2000 to 2003? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Worksheet Running Very Slow | Excel Worksheet Functions | |||
Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) |