Excel 2007 slow to copy entire sheet
I just filled 15 columns x 400 rows with the address of each cell and copied
the sheet to the end of the workbook and it was almost instantly done. Intel
Duo-Core 2.40 GHz (E6600) w/2GB RAM on Vista Ultimate. Do you have a lot of
formulas that have to be recalculated on that sheet?
One thing to look at might be in the Options | Advanced area - scroll down
to the [Formulas] section and make sure it has allow multi-threaded
calculations ticked along with allowing it to use all available CPUs on the
system. That may help.
"mjmattox" wrote:
When I right click on a sheet and select "copy" and copy the sheet to another
workbook it takes Excel nearly 30-60 seconds to complete the operation.
The sheet being copied contains only data, about 15 columns x 400 rows.
This behavior is exhibited when copying from workbooks that are in the new
and old file formats.
I have a new Intel Duo-Core 2.66Ghz and 3Gb RAM.
Any suggestions would be appreciated.
|