XL97: Resolving Conflicts Unhides Previously Hidden Worksheet

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you save a shared workbook and resolve conflicts in the workbook, worksheets that previously were hidden may become visible.

CAUSE

This problem will occur if a conflict occurs on a hidden worksheet.

RESOLUTION

If a conflict occurs on a hidden worksheet, you cannot prevent this problem from occurring. You can, however, manually rehide any worksheets that should be hidden by following these steps:

1. Activate the worksheet that you want to hide.

2. On the Format menu, point to Sheet, and click Hide.

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

When you share a workbook in Microsoft Excel 97, multiple users can simultaneously make changes to the workbook. When you save a workbook that is shared, the Resolve Conflicts dialog box will appear if two or more users have entered different values into a cell in a worksheet in the workbook. You can use the Resolve Conflicts dialog box to determine what value is retained by the cell.

When the Resolve Conflicts dialog box appears, if the worksheet where a conflict occurs is hidden, the worksheet will be unhidden, no matter what button you click (Accept All Mine, Accept All Others, Accept Mine, Accept Other, or Cancel).