XL2001: Excel Hangs When You Attempt to Copy Worksheet in Same Workbook (286266)


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
This article was previously published under Q286266

SYMPTOMS

If you attempt to copy a sheet, Microsoft Excel may stop responding (hang), and you must click Force Quit (press COMMAND+OPTION+ESC), or restart. This may result in the loss of any unsaved data.

CAUSE

This problem occurs when the following conditions are true:
  • A worksheet is copied more than once into its originating workbook, by using any method, including Microsoft Visual Basic for Applications (VBA).

    -and-

  • The workbook contains, or has previously contained, a VBA module.
NOTE: The problem may occur the first time that you copy a sheet in an existing workbook, if there are copies of the same sheet in the workbook from previous use.

RESOLUTION

To resolve this problem, download and install the Microsoft Office 2001 Service Release 1 file. To do so, visit the following Microsoft Web site:

http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/download/office2001/update_905.xml&secid=10&ssid=25&flgnosysreq=True

To temporarily work around this problem, use any of the following methods.

Method 1: Copy a File Only Once

Create only one copy of a sheet. For additional copies, copy the copy, and continue to copy any new copies only once.

Method 2: Copy a File to Another Workbook

Copy a file to another workbook and then move it back into the original workbook.

Method 3: Copy Worksheets Only in Files Without VBA Modules

Copy sheets only in workbooks that have no modules. Use code in a separate workbook.

NOTE: This method may only work if the file is newly created in Excel 2001. Removing existing modules may not solve the problem, but moving the sheets to a new workbook may allow you to copy a sheet multiple times within the new workbook.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2001 for Mac Service Release 1.

REFERENCES

For more information about how to copy sheets, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click C.
  2. Scroll down until you locate copy, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click Move or copy sheets.
If you cannot find the information that you want, ask the Office Assistant.

For additional information about the Office 2001 Service Release, click the article number below to view the article in the Microsoft Knowledge Base:

294949 OFF2001: Readme for Microsoft Office 2001 for Mac Service Release 1 (SR-1)

Or, visit the Microsoft MacTopia Web site (http://www.microsoft.com/mac) for any additional updates.
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kbbug kbdtacode kbpending KB286266
©2004 Microsoft Corporation. All rights reserved.