OLAP cube refresh fail

%3CLINGO-SUB%20id%3D%22lingo-sub-1495507%22%20slang%3D%22en-US%22%3EOLAP%20cube%20refresh%20fail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495507%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20create%20a%20cub%20file%20from%20MS%20Project.%20In%20Excel%20I%20create%20a%20pivot%20table%20based%20on%20the%20cube%20as%20an%20external%20connection.%20So%20far%20Excel%20is%20working%20fine%20and%20the%20pivot%20is%20running.%3C%2FP%3E%3CP%3EHowever%2C%20after%20saving%20the%20xlsx%20and%20reopen%20it%2C%20the%20data%20connection%20cannot%20refresh.%3C%2FP%3E%3CP%3Eolap%3C%2FP%3E%3CP%3EAfter%20checking%20the%20whole%20windows%20system%20together%20with%20the%20ms%20support%20I%20dont%20know%20what%20can%20be%20done%20...%3C%2FP%3E%3CP%3EThank%20you%20for%20help%2C%20Peter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2229-06-_2020_09-34-29.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201808iF9444308447104B5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%2229-06-_2020_09-34-29.jpg%22%20alt%3D%2229-06-_2020_09-34-29.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esystem%3A%20Windows%2010%2064%20%2C%20MS%20365%2C%20MS%20Project%202019%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495507%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498015%22%20slang%3D%22en-US%22%3ERe%3A%20OLAP%20cube%20refresh%20fail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498015%22%20slang%3D%22en-US%22%3E%3CP%3Esolved%20the%20problem%2C%20I%20dont%20know%20if%20it%20is%20an%20Excel%20issue%20...%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20reopen%20the%20excel%20file%2C%20do%20not%20refresh%20data.%20Instead%20choose%20a%20pivot%20table%20field%20and%20do%20some%20action%20with%20it.%20Check%20a%20box%20and%20uncheck%20the%20same%20box%20is%20enough.%20Then%20close%20the%20the%20field%20and%20do%20the%20refresh%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EOne%20cannot%20do%20the%20refreh%20on%20open%20the%20file%2C%20this%20will%20cause%20the%20faul%20of%20the%20refresh.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20Microsoft%2C%20fix%20this%20issue.%3CBR%20%2F%3E%3CBR%20%2F%3Echeers%20Peter%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

29-06-_2020_09-34-29.jpg

 

system: Windows 10 64 , MS 365, MS Project 2019

 

 

1 Reply
Highlighted

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