In this post, you’ll learn about the error message “FormulaEditingNotEnabled – Editing Formulas is not enabled in this release of Excel Services.” that you usually receive when working eith the Excel Services in SharePoint.
When working with SharePoint Excel Services, there are error codes that are generated in the SOAP exception when the errors occur in the Excel Services. You can use the SubCode property that is available in the SoapException class to identity these error codes and troubleshoot the issue.
Error Message
FormulaEditingNotEnabled – Editing Formulas is not enabled in this release of Excel Services.
Reason for the Error
The caller tried to write a formula into the workbook.
Solution
Do not try to write a formula because it is not supported in this release of Excel Services.
