The information in this article applies to:
SYMPTOMSIn 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: The Shared Lists dialog box does not open, and you cannot show the Conflict History in the file. CAUSEThis 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. RESOLUTIONAlthough 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:
STATUSMicrosoft 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 INFORMATIONThe 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):
Additional query words:
Keywords : xlwin |
Last Reviewed: January 6, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |