Can't Show Conflict History in Read-Only File (129278)
The information in this article applies to:
- Microsoft Excel for Windows 95
This article was previously published under Q129278 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.
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB129278 |
---|
|