Excel gets slow with CUBEMEMEBERS. Need an off switch

shophoney

Board Regular
Joined
Jun 16, 2014
Messages
228
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
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,119,061
Messages
5,575,872
Members
412,689
Latest member
nhsmedic
Top