Hi all We have an Excel pivot that is connected to an OLAP Cube using msmdpump and basic authentication. When we create the connection it works fine, but as soon as the workbook is saved and re-opened, we are 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. Office 365. Also tried interacting with the pivot on re-opening without refreshing the data, but that results in the same error messages. Thanks Zelda

OLAP Cube refresh fail on re-opening

Zelda Borchardt 0

Hi all
We have an Excel pivot that is connected to an OLAP Cube using msmdpump and basic authentication. When we create the connection it works fine, but as soon as the workbook is saved and re-opened, we are unable to interact with the pivot or refresh the data. All other users are experiencing the same problem. Errors we are getting:

thumbnail image 1 of blog post titled Excel pivot linked to OLAP CUBE refresh fail once workbook is re-opened

Answer "Yes" and enter password and then error:

thumbnail image 2 of blog post titled Excel pivot linked to OLAP CUBE refresh fail once workbook is re-opened

The connection to datasource works if it is a new connection, but have to recreate the file every time. Office 365.
Also tried interacting with the pivot on re-opening without refreshing the data, but that results in the same error messages. Thanks

Zelda

Share via

OLAP Cube refresh fail on re-opening

Your answer