I didn't read your post closely enough. I see now you wrote that it's on the
copy, not the paste.

But I wouldn't delete the printer drivers--just swap to another printer. That
would have been sufficient for testing my guess.

Sorry, it didn't work.

If you don't have any other modified formatting in that worksheet/workbook, then
I bet changing the font of all the cells won't increase the size of the workbook
(much??). But that's a guess.

Changing the font for an entire column has less impact than changing the font
for a specific range (judging by hitting ctrl-end and seeing where excel where
places your last used cell).

Another silly suggestion...

Try closing excel.
Clean up your windows temp folder
Windows start button|Run
type:
%temp%
and hit enter

Clean all those files that you can. (You may have some files in use, so skip
those.)

Then try your workbook again.

Please post back with your results -- good or bad.

Mike wrote:

Dave,

Thanks for the suggestion. I did delete my default printer and assign the
Microsoft Office Document Image Writer as my default printer. And I am still
getting the issue - no apparent change in speed.

I'm going to try deleting all the printers and see what happens as well.

I've seen this suggestion for various speed problems and my biggest question
about if it is the solution is that when issuing the CTRL-C command, nothing
seems to be changing on the screen. On the paste, yes, there is something
visible changing. I haven't reconciled in my mind why CTRL-C would cause the
issue. But, I'm going to try!

A thought occurred, what about if I did a global change of font on a
spreadsheet? I don't know if I did it on this spreadsheet, but suppose I
wanted to change the default font and selected the entire spreadsheet and
changed it, does that store the info for every cell? Spreadsheet size is
very small -- 32KB, but I suppose it could be trying to "reformat" the entire
spreadsheet every time?? I don't know.

Thanks for the suggestion and I am going to try it out. I am also going to
create a new spreadsheet and copy this spreadsheet's values to it (no
formats) to see if there is a difference.

"Dave Peterson" wrote:

How about a complete guess?

If you change the printer (it doesn't even have to actually exist!), is the
copy|paste quicker?

Maybe it has something to do with the way excel has to determine what to
display????

Mike wrote:

I have a very small spreadsheet (last cell = K176) saved in xlsx format. No
formulas, data is all manually enterd. When I do a copy/paste, the first
instance of a "new" copy (CTRL-C) takes about 5-10 seconds before I get
control of the mouse to paste the data. Subsequent pasting of the same copy
are quick. However, if I copy a new cell, it again takes 5-10 seconds (or
more) before I get control of the mouse. All I have open on my computer is
Excel.

Any help is appreciated!

Computer specs:
OS Name: Microsoft Windows 7 Professional
Version: 6.1.7600 Build 7600
System Model: HP Pavilion dv7 Notebook PC, x64-based PC
Processor: Intel Core i7 Q720 1.60GHz, 1597 Mhz, 4 Cores, 8 Logical Processors
Installed Physical Memory (RAM) 6.00 GB
Total Physical Memory 5.99 GB
Available Physical Memory 3.93 GB
Total Virtual Memory 12.0 GB
Available Virtual Memory 9.67 GB

--

Dave Peterson
.


--

Dave Peterson