VistaPro + Excel 2007- cell copy very very slow

Running Excel 2007 & Vista Pro On New PC w/ plenty of RAM.

When I am in an Excel worksheet & copy a value from one to another, It takes
5 or more seconds after I do the Copy before it will allow me to Paste.

How can this be improved - with Windows 2000 &Excel 2003 it was "instaneous"
!!

Please advise - - Thanks

Same problem here. wonder what it's doing in the background.

"Robert M" wrote:

> Running Excel 2007 & Vista Pro On New PC w/ plenty of RAM.
>
> When I am in an Excel worksheet & copy a value from one to another, It takes
> 5 or more seconds after I do the Copy before it will allow me to Paste.
>
> How can this be improved - with Windows 2000 &Excel 2003 it was "instaneous"
> !!
>
> Please advise - - Thanks

I turned off several services in the Services Control Panel, and rebooted.
Excel2007 copy and paste is instantaneous. If I had to guess, I think it was
the Defender service, which might have been scanning the input of the copy
command

works great now

"Robert M" wrote:

> Running Excel 2007 & Vista Pro On New PC w/ plenty of RAM.
>
> When I am in an Excel worksheet & copy a value from one to another, It takes
> 5 or more seconds after I do the Copy before it will allow me to Paste.
>
> How can this be improved - with Windows 2000 &Excel 2003 it was "instaneous"
> !!
>
> Please advise - - Thanks

Robert M and michael -

Do you by any chance have any formulas or conditionally formatting in
place? I had the same problem where each copy and paste took what seems
like forever. It turns out that my conditional formats were slowing
everything down AND making the file HUGE (>15,000K). Instead of
specifying ranges in my formats like I did in Excel 2003 ($b$1:$b$500),
I decided to take advantage of 2007's new ability to name entire columns
($b:$b). I had about 10 formats written this way. Therefore, each time
I copy/pasted a cell, Excel had to work through all 1,048,576 rows
before it could finish thinking and paste. To fix this, I specified
ranges in all my conditional formats and now the copy/paste works like a
dream!

Hope that helps!


--
peige414