OFF2000: Shared Workbooks Stored on Office Web Server Open Read-Only

• Microsoft Office 2000
• Microsoft Excel 2000

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.

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.

CAUSE

This problem will occur then the following conditions are true:

• The file is a shared workbook.


-and-


• The workbook is stored on a Web server that is running the Office Server Extensions.


-and-


• Another user currently has the workbook open.

WORKAROUND

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

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.

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.

Additional query words: OFF2000 XL2000 OSEClient OSE read only

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb