Jun 29 2020 01:40 AM
Hi all,
I create a cub file from MS Project. In Excel I create a pivot table based on the cube as an external connection. So far Excel is working fine and the pivot is running.
However, after saving the xlsx and reopen it, the data connection cannot refresh.
olap
After checking the whole windows system together with the ms support I dont know what can be done ...
Thank you for help, Peter
system: Windows 10 64 , MS 365, MS Project 2019
Jun 30 2020 02:36 AM - edited Jun 30 2020 03:52 AM
solved the problem, I dont know if it is an Excel issue ...
After reopen the excel file, do not refresh data. Instead choose a pivot table field and do some action with it. Check a box and uncheck the same box is enough. Then close the the field and do the refresh :)
One cannot do the refreh on open the file, this will cause the faul of the refresh.
Please Microsoft, fix this issue.
cheers Peter
Aug 26 2022 02:08 AM