Hi I have a 100mb Excel file that takes 20 minutes to refresh.
I'm wondering if I can delay the updating of the tabs till I select the page. Or have a macro button not to screen update the changes.
All my data comes in through power query from a sql database. It's uploaded to powerpivot and then on the sheets with mostly cubemembers and values.
When i deleted some of the tabs it cut the time to 5 minutes.
I think because it's updating all the tabs (25 tabs). Can it be delayed to the click on the tab,
Thanks
I'm wondering if I can delay the updating of the tabs till I select the page. Or have a macro button not to screen update the changes.
All my data comes in through power query from a sql database. It's uploaded to powerpivot and then on the sheets with mostly cubemembers and values.
When i deleted some of the tabs it cut the time to 5 minutes.
I think because it's updating all the tabs (25 tabs). Can it be delayed to the click on the tab,
Thanks