Symptom
After refreshing your datasource you receive the following error message:
"Could not clear component Crosstab (ID-103021)"
The AO_Trace file also contains the following:
"YYYY-MM-DD HH:MM:SS|WARN|Trace.AoPlugin|com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog|VSTA_Main|103021 Could not clear component Crosstab 1. Range: (0,0)(20,581) Sheet1[msg.ClearItem]#"
"YYYY-MM-DD HH:MM:SS|WARN|Trace.AoPlugin|com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog|VSTA_Main|General .NET Exception:
This command is not available in a shared workbook."
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
- Open the workbook
- Refresh datasource
Cause
The workbook is a shared workbook. The usage of Analysis Office in shared workbooks for simultaneous editing of several people is not supported.
Resolution
To unshare the workbook, open the Review ribbon and select the "Share Workbook" option.
On the following dialog box, under Editing tab, uncheck the "Allow changes by more than one user at the same time" option.
Click Ok and then click Yes in the warning prompt.
The workbook is now unshared and the workbook can be refreshed without any error.
See Also
SAP Note 1853386 - Using Analysis Office in shared workbooks
Keywords
crosstab, refresh, shared, 103021 , KBA , BI-RA-AO-XLA , Excel Addin , Problem