Cannot change the value of a cell that contains an array formula in a workbook that is saved to a SharePoint site that is running Excel Services in SharePoint Server 2010

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
Consider the following scenario:
  • You have a server that is running Excel Services in Microsoft Office SharePoint Server 2010.
  • On this server, you have a Microsoft Excel workbook that is saved to a SharePoint site.
  • You edit the workbook.
  • You type a new value into a cell that contains an array formula.
In this scenario, the contents of the cell changes to show to the new value and then the contents of the cell changes back to the array formula. However, you do not receive an error message.
WORKAROUND
To work around this behavior, follow thesesteps:
  1. Open the Excel workbook in the client version of Microsoft Excel 2010.
  2. Make the change to the cell value.
  3. Save the Excel workbook to the SharePoint site.
Properties

Article ID: 982707 - Last Review: 12/12/2015 04:22:45 - Revision: 2.0

Microsoft SharePoint Server 2010, Microsoft Excel 2010

  • kbnosurvey kbarchive kbtshoot kbexpertiseinter kbsurveynew kbprb KB982707
Feedback