Results 1 to 5 of 5

Thread: Excel hangs when copying

  1. #1
    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?

  2. #2
    Join Date
    May 2008
    Posts
    4,574

    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.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,644

    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.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,089

    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.

  5. #5
    Join Date
    May 2008
    Posts
    3,319

    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.

Similar Threads

  1. while copying J.Edgar DVD AnyDVD hangs
    By Dhano in forum Windows Software
    Replies: 2
    Last Post: 11-03-2012, 09:35 PM
  2. Replies: 2
    Last Post: 17-02-2012, 12:16 PM
  3. Excel 2007 hangs when opening network file
    By Digamber in forum Windows Software
    Replies: 6
    Last Post: 12-09-2011, 08:41 PM
  4. My Microsoft Word and Excel hangs up.
    By Dharmavira in forum Windows Software
    Replies: 2
    Last Post: 14-02-2009, 11:47 AM
  5. Excel Issue while Copying Formula
    By Ameya in forum Windows Software
    Replies: 1
    Last Post: 27-01-2009, 12:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •