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

Article translations Article translations
Article ID: 982707 - View products that this article applies to.
Expand all | Collapse all

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: September 18, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft SharePoint Server 2010
  • Microsoft Excel 2010
Keywords: 
kbtshoot kbexpertiseinter kbsurveynew kbprb KB982707

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com