Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Shared workbooks that are stored on Office Web server open as read-only in Excel 2000


View products that this article applies to.

Symptoms

When you open an Excel workbook, you receive the following message:
<File name> is locked for editing

by <User name>.

Click 'Notify' to open a read-only copy of the document and receive notification when the document is no longer in use.
where <File name> is the name of the file you are opening, and <User name> is the name of the user who currently has full edit control (Read-Write) of the file.

When you click a hyperlink on your Office Server Extensions home page to open an Excel workbook, you receive the following message:
File is locked. In order to save changes to the file, you can either close the file before making any changes and then re-open it, use Save As (File menu) to save the file using another filename, or turn off Shared Workbooks and then save the file.

↑ Back to the top


Cause

This problem will occur then the following conditions are true:
  • The file is a shared workbook.
  • The workbook is stored on a Web server that is running the Office Server Extensions.
  • Another user currently has the workbook open.

↑ Back to the top


Workaround

To work around this issue, save your shared workbook to a network drive, and not an Office Server Extended Web Server.

↑ Back to the top


More information

Shared workbooks do not work as expected on Web servers; they behave the same as "unshared" workbooks. That is to say, at any given time only one user will be able to open the workbook for editing (Read-Write), all other users can only open the file as Read-Only.

↑ Back to the top


References

For more information about Shared Workbooks, click Microsoft Excel Help on the Help menu, type Shared Workbooks in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB229483, kbopenfile, kbpending, kbprb, kbnetwork, kberrmsg

↑ Back to the top

Article Info
Article ID : 229483
Revision : 4
Created on : 9/28/2004
Published on : 9/28/2004
Exists online : False
Views : 214