[Resolved] Hidden cells not hidden in shared workbooks RRS feed

  • General discussion

  • Had an issue with my accountants using shared workbooks in Office 2010 where the hidden cells created by one user were not hidden when another user opened. I scoured the internet for a solution and found plenty of other people having the problem but didn't really see any solutions. Saw a few things about macros, but none of the workbooks I was troubleshooting had macros in them. I stumbled upon a fix that actually worked for me and thought I'd share it for anyone else that ran into the same problem I had finding a solution.

    Within the shared workbook, click in the upper left corner to highlight all cells. Right-click on any of the highlighted cells and select Format Cells, go to the Protection tab and check Hidden, Click OK, save the document, make your changes and save the document again. Tested in multiple scenarios with different users and was able to replicate the results each time in my environment. Hope that helps someone out.

    • Edited by Steve Fan Friday, June 27, 2014 7:04 AM shared solution
    • Changed type Steve Fan Friday, June 27, 2014 7:04 AM shared solution
    Thursday, June 26, 2014 1:51 PM

All replies

  • I will test that, i stumbled upon the same error.
    Thursday, June 26, 2014 2:02 PM
  • I'd be very interested to hear if it worked for anyone else.

    Thursday, June 26, 2014 2:04 PM
  • Thank you for sharing your experience here. It would be helpful to other community members who have similar issue.


    Steve Fan
    TechNet Community Support

    Friday, June 27, 2014 7:05 AM