Optimize CubeView performance in Excel
I have Cubeview which takes ~50 secs to refresh in OS.
When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins.
It is simple insert and refresh i.e. I do ...
Forum Discussion
You can turn the below properties to false from preferences -> Enable macro -> False and Invalidate old data -> False.