cancel
Showing results for 
Search instead for 
Did you mean: 

Optimize CubeView performance in Excel

aneupane
New Contributor III

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 not have anything additional like VBA code etc in Excel.

  1. Is it normal for CV to take to take longer to refresh in excel?
  2. Any suggestion to optimize the Cube view refresh in Excel?

Many Thanks.

3 REPLIES 3

BobMarchese
New Contributor III

I am curious if you have tried opening this using Spreadsheet, and seeing what the refresh time is in there.  I believe that's a direct connection to the database and may tell you if it's an issue with the add-in or with the cube view design itself somehow.

aneupane
New Contributor III

Thank you Bob. Great suggestion for troubleshooting. I tired and indeed the refresh time reduces to 1 mins 20 secs (down from 2 mins 20 secs). One step closer...I believe next step is to diagnose what is slowing in excel addin. 

Manish_Agrawal
New Contributor III

You can turn the below properties to false from preferences -> Enable macro -> False and Invalidate old data -> False.