Excel gets slow with CUBEMEMEBERS. Need an off switch

shophoney

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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,118,186
Messages
5,570,750
Members
412,340
Latest member
nikitesh95
Top