Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel hangs when copying

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 31-07-2010
Member
 
Join Date: Apr 2010
Posts: 32
Excel hangs when copying
  

I am having issues with my Excel 2007. The problem occurs when I try to copy anything from my Excel sheet and paste it any where else on the same file or somewhere else. It either sometimes hangs for certain interval or doesn't perform anything. This happens only on my Excel sheets but not anywhere else. I didn't noticed this strange behaviour on my Word or PowerPoint. What should be the problem according to you?

Reply With Quote
  #2  
Old 31-07-2010
Member
 
Join Date: May 2008
Posts: 4,564
Re: Excel hangs when copying

This problem occurs when you copy from a worksheet with formulas that contain 3-D references if the formulas contain #REF! values. The #REF! values within these formulas are usually generated when you make copies of worksheets that are themselves copies of other worksheets containing formulas with 3-D references.
Reply With Quote
  #3  
Old 31-07-2010
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: Excel hangs when copying

Maybe the file has been corrupted. I would suggest you to try roundtripping the file. Save the file as web page (HTML) and close it. Now open this saved HTML document in Excel and resave as Excel workbook.
Reply With Quote
  #4  
Old 31-07-2010
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: Excel hangs when copying

Did you tried to save the content into some text editor and then pasting it into the desired location? What happens if you do so? Have you done any formatting with the content and are unable to save it or which is causing you the problem? What happens if you use "Paste Special" in excel? There may be some kind of conflict due to which it is hanging.
__________________
Ram requirement for various OS
Reply With Quote
  #5  
Old 31-07-2010
Member
 
Join Date: May 2008
Posts: 3,312
Re: Excel hangs when copying

Did you installed any add-ins, most probably recently which is causing you this problem? Do you have any macros in your Excel sheet running automatically based on sheet updates or other events ? Remove or disable them all and see if it helps. Also try to create a new blank worksheet and try to copy and pasting some content to make sure if that happens with this Excel file too.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel hangs when copying"
Thread Thread Starter Forum Replies Last Post
while copying J.Edgar DVD AnyDVD hangs Dhano Windows Software 2 11-03-2012 09:35 PM
How to keep the formatting as it is after copying content from Word to Excel Eeshika18 MS Office Support 2 17-02-2012 12:16 PM
Excel 2007 hangs when opening network file Digamber Windows Software 6 12-09-2011 08:41 PM
My Microsoft Word and Excel hangs up. Dharmavira Windows Software 2 14-02-2009 11:47 AM
Excel Issue while Copying Formula Ameya Windows Software 1 27-01-2009 12:03 PM


All times are GMT +5.5. The time now is 01:48 AM.