Optimize CubeView performance in Excel

[aneupane]

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.

[BobMarchese]

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]

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. 

[OS_Pizza]

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