This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel, when you save a shared workbook and resolveconflicts in the workbook, worksheets that previously were hidden maybecome visible.
This problem will occur if a conflict occurs on a hidden worksheet.
If a conflict occurs on a hidden worksheet, you cannot prevent this problemfrom occurring. You can, however, manually rehide any worksheets thatshould be hidden by following these steps:
Switch to the worksheet that you want to hide.
On the Format menu, point to Sheet, and then click Hide.
After you have rehidden any of the worksheets you want to hide, save theworkbook.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
When you share a workbook in Microsoft Excel, multiple users cansimultaneously make changes to the workbook. When you save a workbook thatis shared, the Resolve Conflicts dialog box will appear if two or more users have typed different values into a cell in a worksheet in theworkbook. 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).