Article ID: 286266 - View products that this article applies to.
This article was previously published under Q286266
This article has been archived. It is offered "as is" and will no longer be updated.
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.
This problem occurs when the following conditions are true:
To resolve this problem, download and install the Microsoft Office 2001 Service Release 1 file.
Note The Microsoft Office 2001 Service Release 1 (SR-1) update is no longer available as a separate download. To obtain Microsoft Office 2001 Service Release 1 (SR-1), download and install the Microsoft Office 2001 Combined Update 9.0.5. To do so, visit the following Microsoft Web site:
Microsoft Office 2001 for Mac Security Update (9.0.5)
To temporarily work around this problem, use any of the following methods.
Method 1: Copy a File Only OnceCreate 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 WorkbookCopy a file to another workbook and then move it back into the original workbook.
Method 3: Copy Worksheets Only in Files Without VBA ModulesCopy 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.
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.
For more information about how to copy sheets, follow these steps:
For additional information about the Office 2001 Service Release, click the article number below to view the article in the Microsoft Knowledge Base:
294949Or, visit the Microsoft MacTopia Web site (http://www.microsoft.com/mac
(http://support.microsoft.com/kb/294949/EN-US/ )OFF2001: Readme for Microsoft Office 2001 for Mac Service Release 1 (SR-1)
(http://www.microsoft.com/mac)) for any additional updates.
Contact us for more help
Connect with Answer Desk for expert help.