XL7: Conflict History Information Lost in Exclusive Workbook

ID: Q130559

7.00 WINDOWS kbother kbwwt 

 --------------------------------------------------------------------
The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you stop sharing a workbook by clearing the Allow Multi-User Editing check box in the Shared Lists dialog box, the Conflict History worksheet is removed from the workbook. Additionally, if you later share the workbook again and add the Conflict History worksheet again, the information previously displayed on the Conflict History worksheet no longer appears.

CAUSE

This behavior is by design. When you stop sharing a workbook, a dialog box with the following warning appears: 

   Warning! This action will prevent other users from saving their work
   to this file! They will have to save to a different file, even if you
   later make this file shared again. Proceed?
If you choose Yes, the file is no longer shared, and the Conflict History worksheet (if it was displayed in the workbook) is removed. Additionally, the conflict information that was displayed on this worksheet is not saved.

If you later reshare the workbook, the conflict history from the first time you shared the workbook is no longer available. The conflict history information for each workbook is only stored while the file is shared.

KBCategory: kbother kbwwt KBSubcategory: xlwin

Additional reference words: 7.00 

Keywords          : xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 30, 1997