A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007: Slow copy/paste



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 01:45 PM posted to microsoft.public.excel.misc
mike
external usenet poster
 
Posts: 3,942
Default Excel 2007: Slow copy/paste

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

  #2  
Old April 16th, 2010, 05:08 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Excel 2007: Slow copy/paste

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
  #3  
Old April 16th, 2010, 07:39 PM posted to microsoft.public.excel.misc
mike
external usenet poster
 
Posts: 3,942
Default Excel 2007: Slow copy/paste

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
.

  #4  
Old April 16th, 2010, 10:31 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Excel 2007: Slow copy/paste

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
  #5  
Old April 19th, 2010, 03:25 PM posted to microsoft.public.excel.misc
mike
external usenet poster
 
Posts: 3,942
Default Excel 2007: Slow copy/paste

Dave,

Thanks again for the reply.

Here is what I did:

1. Created a new spreadsheet and just copied values from my old spreadsheet
to the new one. I did not format the spreadsheet in any way. Closed the
spreadsheet.
2. Deleted print drivers except for the default Windows 7 drivers (i.e., the
Fax driver, XPS Document Writer)
3. Cleaned up everything I could out of my %temp% directory
4. Rebooted.
5. Reopened Excel and the spreadsheet
6. Located a random cell and did "CTRL-C"
7. It took about 10 seconds to get control of my spreadsheet for the paste
command
8. Paste goes very quickly; second "CTRL-C" or even just starting to type
directly into a cell gives me the "busy" icon for about 10 seconds again.

This is entirely repeatable - occurs everytime.

Even closing the spreadsheet after this causes Excel to go into "Not
responding" for about 10-15 seconds. CTRL-C seems to be the only issue.

I tried a different spreadsheet (again, very small - no formulas, text
manually entered in cells only) and it reacts the same way.

Mike
  #6  
Old April 19th, 2010, 04:22 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Excel 2007: Slow copy/paste

Thanks for posting back, but I don't have a suggestion.

Maybe someone who has seen this problem will chime in.

Mike wrote:

Dave,

Thanks again for the reply.

Here is what I did:

1. Created a new spreadsheet and just copied values from my old spreadsheet
to the new one. I did not format the spreadsheet in any way. Closed the
spreadsheet.
2. Deleted print drivers except for the default Windows 7 drivers (i.e., the
Fax driver, XPS Document Writer)
3. Cleaned up everything I could out of my %temp% directory
4. Rebooted.
5. Reopened Excel and the spreadsheet
6. Located a random cell and did "CTRL-C"
7. It took about 10 seconds to get control of my spreadsheet for the paste
command
8. Paste goes very quickly; second "CTRL-C" or even just starting to type
directly into a cell gives me the "busy" icon for about 10 seconds again.

This is entirely repeatable - occurs everytime.

Even closing the spreadsheet after this causes Excel to go into "Not
responding" for about 10-15 seconds. CTRL-C seems to be the only issue.

I tried a different spreadsheet (again, very small - no formulas, text
manually entered in cells only) and it reacts the same way.

Mike


--

Dave Peterson
  #7  
Old April 19th, 2010, 07:10 PM posted to microsoft.public.excel.misc
Roger Govier[_8_]
external usenet poster
 
Posts: 338
Default Excel 2007: Slow copy/paste

Hi Mike

I have no idea what the problem is, but I would be more than happy to
take a look on my computer if you want to send me a copy of the file.
To mail direct
roger at technology4u dot co dot uk
Change the at and dots to make a valid email address.

--
Regards
Roger Govier

Mike wrote:
Dave,

Thanks again for the reply.

Here is what I did:

1. Created a new spreadsheet and just copied values from my old spreadsheet
to the new one. I did not format the spreadsheet in any way. Closed the
spreadsheet.
2. Deleted print drivers except for the default Windows 7 drivers (i.e., the
Fax driver, XPS Document Writer)
3. Cleaned up everything I could out of my %temp% directory
4. Rebooted.
5. Reopened Excel and the spreadsheet
6. Located a random cell and did "CTRL-C"
7. It took about 10 seconds to get control of my spreadsheet for the paste
command
8. Paste goes very quickly; second "CTRL-C" or even just starting to type
directly into a cell gives me the "busy" icon for about 10 seconds again.

This is entirely repeatable - occurs everytime.

Even closing the spreadsheet after this causes Excel to go into "Not
responding" for about 10-15 seconds. CTRL-C seems to be the only issue.

I tried a different spreadsheet (again, very small - no formulas, text
manually entered in cells only) and it reacts the same way.

Mike

  #8  
Old April 20th, 2010, 08:37 PM posted to microsoft.public.excel.misc
mike
external usenet poster
 
Posts: 3,942
Default Excel 2007: Slow copy/paste

Dave,

Thanks for trying. This issue appears to be environmental, as I took the
spreadsheet to another computer and it works fine. Biggest difference
between the two computers is the issue occurs on a box running Windows 7 Pro
and it is fine on a box running XP Pro.

Mike
  #9  
Old April 20th, 2010, 08:38 PM posted to microsoft.public.excel.misc
mike
external usenet poster
 
Posts: 3,942
Default Excel 2007: Slow copy/paste

Thanks for the offer. I am going to do a little more research here.

This issue appears to be environmental, as I took the spreadsheet to another
computer and it works fine. Biggest difference between the two computers is
the issue occurs on a box running Windows 7 Pro and it is fine on a box
running XP Pro.

Mike


"Roger Govier" wrote:

Hi Mike

I have no idea what the problem is, but I would be more than happy to
take a look on my computer if you want to send me a copy of the file.
To mail direct
roger at technology4u dot co dot uk
Change the at and dots to make a valid email address.

--
Regards
Roger Govier

Mike wrote:
Dave,

Thanks again for the reply.

Here is what I did:

1. Created a new spreadsheet and just copied values from my old spreadsheet
to the new one. I did not format the spreadsheet in any way. Closed the
spreadsheet.
2. Deleted print drivers except for the default Windows 7 drivers (i.e., the
Fax driver, XPS Document Writer)
3. Cleaned up everything I could out of my %temp% directory
4. Rebooted.
5. Reopened Excel and the spreadsheet
6. Located a random cell and did "CTRL-C"
7. It took about 10 seconds to get control of my spreadsheet for the paste
command
8. Paste goes very quickly; second "CTRL-C" or even just starting to type
directly into a cell gives me the "busy" icon for about 10 seconds again.

This is entirely repeatable - occurs everytime.

Even closing the spreadsheet after this causes Excel to go into "Not
responding" for about 10-15 seconds. CTRL-C seems to be the only issue.

I tried a different spreadsheet (again, very small - no formulas, text
manually entered in cells only) and it reacts the same way.

Mike

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.