12-01-2021 02:12 PM
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.
12-02-2021 02:48 PM
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.
12-03-2021 04:33 AM
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.
01-25-2022 05:49 AM
You can turn the below properties to false from preferences -> Enable macro -> False and Invalidate old data -> False.