You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

Cell content is displayed as #N/A! after you enable editing in a workbook in Protected View in Excel 2010 or Excel 2013

Symptoms

Assume that you open a workbook in protected view in Microsoft Excel 2010 or Excel 2013. The workbook contains the Cell function. After you click Enable Editing, the content in each cell in the workbook is displayed as #N/A!.

Workaround
To work around this issue, press F9 to update the workbook.

Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 2761239 - Last Review: 11/30/2012 11:48:00 - Revision: 1.0

  • Microsoft Excel 2013
  • Microsoft Excel 2010
  • kbinfo kbprb kbsurveynew kbexpertisebeginner KB2761239
Feedback
>>