12-01-2021 02:12 PM - last edited on 05-24-2023 11:57 AM by JackLacava
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.
Many Thanks.
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.
07-20-2023 03:37 PM
I have a smilar issue. Changing these settings does not reduce the time to refresh the workbook. Also if I populate lots of cells (ca. > 100) in the CV in Excel it takes very long that the cells get yellow (indicating that data is not in DB). When I hit submitt Excel crashes. So I think the Addin is not made for massdata submission or lager CubeViews.