Symptom
After changing a value of an input-ready cell in Analysis Office, either manually or via VBA code, the "Save Data" button remains disabled in Planning group. It is not possible to save the planning data.
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Cause
The Save Data button remains disabled until selecting another cell (e.g. changing the focus to another cell). This is not a bug but the implemented behavior of the tool.
Resolution
After changing the value of an input-ready cell, it is necessary to click on any other cell or change the focus to another cell via VBA code, in order to enable the Save Data button.
Keywords
activated, disabled, activate, enable, enabled, greyed out, not available, planning, plan data , KBA , BI-RA-AO-XLA , Excel Addin , Problem