View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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.