Excel Powerpivot pivots constantly refreshing

[masplin]

My understanding is that in Excel 2016 if you keep the focus on the datamodel the workbook pivots should NOT refresh. However my model refreshes pretty much ever time I enter anything in the datamodel which is making it extremely tiresome trying to build out the formulae. Is there some setting I could have changed by accident as would like to get back to the default behaviour i.e. no refresh unless i change focus to the workbook?

Thnaks
Mike

 

[sandy666]

Check: Data - Connections - Properties - ...
I assume there is no any VBA

 

[masplin]

none just the model

 

[sandy666]

by default PT should be refreshed on Refresh All
maybe try to recreate PT from the begining

 

[masplin]

sorry this is not refreshing the data this is refreshing the pivot tables. One extremely annoying feature of Excel 2013 was that every time you hit enter in the data model the pivots refreshed. OLAP Extensions fixed this issue but allowing you to disable the pivot refresh. They fixed this in Excel 2016 and usually this is the case, but in this model it doesn't stop it. So i'm trying to write a bunch of measures and in the background the pivot tables start to refresh stopping me working. I have to go to the workbook and hit escape 30 times to kill off the pivot refresh.

 

[sandy666]

maybe change calculation in DataModel to manual

 

[masplin]

doesnt affect pivot table refresh as tried that.

 

[sandy666]

• try the same file on other computer.
• turn off other add-ins

...
I've no more idea