You are currently offline, waiting for your internet to reconnect

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

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: 09/18/2011 23:23:00 - Revision: 2.0

  • Microsoft SharePoint Server 2010
  • Microsoft Excel 2010
  • kbtshoot kbexpertiseinter kbsurveynew kbprb KB982707
Feedback