XL2000: "This File Has Been Locked" Error Message Saving Shared Workbook (130494)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q130494

ERROR MESSAGE

When you save a shared workbook, you may receive one of the following error messages.
This file has been locked by user name for saving. Please try again later.
where user name is the name of another user who has the file open for editing.

-or-
Document saved as 'numchar'. Cannot rename to 'filename'. You must close this document.
where numchar is a combination of numbers and characters such as 0ae06000 and filename is the name of the file you are saving, such as Book1.xls.

NOTE: Microsoft Office 2000 has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to enable this functionality for this and other error messages in Microsoft Office 2000, please download the Microsoft Office 2000 Customizable Alerts file from the Microsoft Office Update Web site at the following address:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8FBEE1D3-C5BB-4A36-A2F7-DC63DE2A818C

NOTE: If you reached this article by clicking the Web Info button in an error message, you already have Customizable Alerts enabled.

CAUSE

This behavior occurs when you save a shared workbook while another user is also saving the same file. This behavior occurs because the workbook is locked during the save process and cannot be saved by another user until the save process is complete.

THINGS TO TRY

To work around this behavior, wait a few minutes (depending on the size of the file) until the save process is complete, and then try saving the file again.

MORE INFORMATION

This error message may appear when you save a file immediately after another user saves the same file. When you save an Excel workbook file, the following process occurs:
  • The original file (for example, Book1.xls) is locked.
  • The original file is saved to a temporary file (0ae06000).
  • The original file (Book1.xls) is unlocked.
  • The original file (Book1.xls) is deleted.
  • The temporary file (0ae06000) is renamed to the original file name (Book1.xls).
If you save a shared workbook while it is being saved by another user, you receive the error message described in the "Symptoms" section in this article. This problem occurs when your save process begins after the file is deleted and before it is renamed (by the first save process) or when the save process you initiated locks the file after it is unlocked (by the first save process). It is unlikely that you will receive the second error message; it appears only in the case when two save processes for one file begin almost at the same moment.
Modification Type:MinorLast Reviewed:12/2/2005
Keywords:kbdownload kbprb KB130494
©2004 Microsoft Corporation. All rights reserved.