Forum Discussion

pehir's avatar
pehir
Copper Contributor
Jun 29, 2020

OLAP cube refresh fail

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

 

 

excel

2 Replies

  • pehir's avatar
    pehir
    Copper Contributor
    Jun 30, 2020

    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

    • ST_21_Li's avatar
      ST_21_Li
      Copper Contributor
      Aug 26, 2022
      Thanks for posting this. I had exactly the same issue and was ready to despair as I just built a dashboard based on this MS Project data export. I assume it's some sort of issue with the way Excel links to the file on the filesystem.

      Who knows if this will ever get fixed. I will setup a macro in the short term to perform this action and data refresh all in one go.

Resources