#N/A when transitioning out of Protected View when the workbook contains a semi-volatile function like Cell

If you open a file in protected mode that contains certain volatile functions (i.e. =CELL()). After clicking Enable Editing, the contents of the cells turn to #N/A! errors.

Press F9 to re-calculate the sheet, and the functions should start working.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.