Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Resolving conflicts unhides previously hidden worksheet in Excel for Mac

View products that this article applies to.

This article was previously published under Q173614

↑ Back to the top


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

↑ Back to the top


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

↑ Back to the top


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. Switch to the worksheet that you want to hide.
  2. On the Format menu, point to Sheet, and then click Hide.
After you have rehidden any of the worksheets you want to hide, save the workbook.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

When you share a workbook in Microsoft Excel, 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 typed 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).

↑ Back to the top

Keywords: KB173614, kbprb, dftsdahomeportal

↑ Back to the top

Article Info
Article ID : 173614
Revision : 5
Created on : 6/25/2010
Published on : 6/25/2010
Exists online : False
Views : 36