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 piv...
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.