3425056 - Work Status(Lock) cannot be detected in opened AO workbook

The new Work Status(Lock) cannot be detected in opened AO workbook. It seems the Work Status was only checked once when the workbook is open. Then, if execute a planning function or a planning sequence to change the data in the infoprovider, no error occurs even the data is locked by the Work Status.

SAP Analysis for Microsoft Office

1. Open AO workbook.
2. Change the Work Status in BPC(no Lock -> Lock).
3. Run a planning function in AO workbook. The new Work Status(Lock) cannot be detected. No error occurred.

System Design

It is a system design that Work Status can only be loaded from BPC when the workbook is opened, so if it is changed later and then the planning function is executed, the new status of Work Status cannot be considered. 

As a workaround,  use SAPLogOff to log off from the system and reconnect automatically. For example, create a VBA button and assign following VBA function to execute the planning function:

Sub LogoffReconnectExecPF()
Dim lResult As Long

lResult = Application.Run("SAPLogOff", True)
lResult = Application.Run("SAPExecutePlanningFunction", "PF_1")

End Sub

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE

workstatus, Analysis for Office, A4O, Analysis for Excel, AFO, locking , KBA , BI-RA-AO-XLA , Excel Addin , How To