Forum Discussion
Excel pivot linked to OLAP CUBE refresh fail once workbook is re-opened
Hi all
I have an Excel pivot that is connected to an OLAP Cube. When I create the connection it works fine, but as soon as the workbook is saved and re-opened, I am unable to interact with the pivot or refresh the data. All other users are experiencing the same problem.
Errors we are getting:
Answer "Yes" and enter password and then error:
The connection to datasource works if it is a new connection, but have to recreate the file every time which is very frustrating. Office 365.
Tried interacting with the pivot on re-opening without refreshing the data, but that results in the same error messages.
Thanks
Zelda
2 Replies
After reconnecting the PivotTable, ensure you have the correct settings configured for the connection.
1. Open the Workbook and go to the Data tab on the Ribbon.
2. Click on Connections.
3. Select the OLAP connection and click on Properties.
4. In the Connection Properties window, check the Definition tab. Ensure that the "Use the following User Name and Password" is selected with the correct credentials if required.Ensure that your user account has the required permissions to access the OLAP cube. Missing permissions can lead to refresh failures when reopening the workbook.
