• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 732
  • Last Modified:

Microsoft Excel 2007 Hangs When Cutting And Pasting To One Particular Worksheet On Vista

Good morning,

A customer of ours recently contacted us to say that she was having problems cutting and pasting data from one worksheet within an Excel 2007 document to another. It's only one particular worksheet proving to be a problem. For example, I can easily cut and paste text from worksheet 1 to worksheets 2 and 3, but if I try pasting to worksheet 4 Excel will hang for around 20-30 seconds before implementing the data. This will even occur if I'm only pasting two or three lines. If I copy and paste text as opposed to cutting and pasting we have absolutely no issues whatsoever.

I asked the user to e-mail me the document so that I could test it from our offices. Using Excel 2003 on an XP platform threw up no problems, so I decided to test it using a Vista PC using Office 2007 from within our office environment. I encountered exactly the same problem as the user.

So far I have tried saving the document as different file types (Excel 97-03 Worksheet, Macro-Enabled Worksheet), have disabled Windows Defender, have tried moving the data to another document (problem persisted) and have just opened the Task Manager and monitored the CPU/Memory Usage while I cut and paste. As soon as I hit 'paste' the CPU usage for Excel.exe soars to 50 and the memory gradually gets larger. Once the paste is complete the CPU returns to 00 and the memory usage gradually gets lower before settling.

I'm not overly familiar with the workings of Excel, so I'm not sure whether there could be any formulas active that are causing this particular problem. The only difference between this worksheet and the others is that this has considerably more lines of data (around 240, whereas the others average around 35/40).

If anyone could provide me with any possible explanations or troubleshooting methods I'd be most grateful! Thanks a lot for your help.
0
msbccs
Asked:
msbccs
  • 6
  • 4
1 Solution
 
Rory ArchibaldCommented:
Can you post the workbook here (overwriting any sensitive information with dummy data first)?
Regards,
Rory
0
 
msbccsAuthor Commented:
Thanks very much for your quick response rorya. I could certainly give it a go, though there is a lot of information within the various workbooks and it may take a while to manually overwrite it all!
0
 
Rory ArchibaldCommented:
I just need two sheets - the problem one and one other, and only a small sample of data, as long as the problem still persists in the stripped-down copy! :)
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
msbccsAuthor Commented:
Okay then, great! Thanks very much. I'll try to get this done for you by the end of the day!
0
 
msbccsAuthor Commented:
I've attached the file as requested. Cheers rorya!
0
 
msbccsAuthor Commented:
Or at least, I thought I had... I'll try again.
Test-Document-1---Copy.xlsx
0
 
Rory ArchibaldCommented:
There are over 16,000 shapes on that sheet, which is what is causing the slowdown! If you delete them ( f5, Special..., select Objects and press OK - then wait! Then when Excel starts responding again, press Delete and wait again. Then save the document.
See attached version.
HTH
Rory
Test-Document-1---Copy.xlsx
0
 
msbccsAuthor Commented:
Rorya, you're a genius. That seems to have done the trick! Brilliant job, thanks very much for your help!!
0
 
msbccsAuthor Commented:
Exceptionally helpful and informative.
0
 
Rory ArchibaldCommented:
Glad to help - thanks for the grade! :)
Rory
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now