XL7: Can't Show Conflict History in Read-Only File

Last reviewed: September 13, 1996
Article ID: Q129278

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you click Shared Lists on the File menu, you receive the following error message if the file is open as read-only:

   Can't access read-only document '<filename.xls>'

The Shared Lists dialog box does not open, and you cannot show the Conflict History in the file.

CAUSE

This behavior occurs because when a file is open as read-only, you cannot change the status of the Multi-User Editing feature in the file. When you change the status of the Multi-User Editing feature in a file, Microsoft Excel requires that you then save the file. When a file is open as read- only, you cannot display the Shared Lists dialog box.

RESOLUTION

Although you cannot display the Shared Lists dialog box in a read-only file, you can display the Conflict History by running the following procedure in a Visual Basic module:

   Sub Conflict_History()
      ' In the following commands, replace BOOK1.XLS
      ' with the name of the file that is open read-only
      Workbooks("BOOK1.XLS").Activate
      Workbooks("BOOK1.XLS").ShowConflictHistory = True
   End Sub

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The Conflict History is a worksheet that contains information (such as Date, Time, Cell Location, and Value) about conflicting cells in the workbook as a result of multiple people editing the same file. To display the Conflict History, do the following (the file must be open with read- write protection):

  1. On the File menu, click Shared Lists.

  2. Click the Editing tab.

  3. Click the Show Conflict History check box, and click OK.

A Conflict History worksheet is inserted in your workbook with the information about the conflicting cells on the worksheet.


KBCategory: kbother
KBSubcategory: xlwin

Additional reference words: 7.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.