How to disable auto-refresh in excel when updating the data model

%3CLINGO-SUB%20id%3D%22lingo-sub-2937914%22%20slang%3D%22en-US%22%3EHow%20to%20disable%20auto-refresh%20in%20excel%20when%20updating%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2937914%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20update%20the%20data%20model%20in%20Power%20Pivot%20with%20a%20new%20calculated%20column%20or%20a%20new%20measure%2C%20excel%20automatically%20refreshes%20all%20the%20pivot%20tables%20in%20the%20file.%20This%20takes%20more%20than%202%20minutes%20per%20change.%20How%20do%20I%20disable%20this%20feature%3F%20I%20have%20disabled%20the%20'Refresh%20this%20connection%20on%20Refresh%20All'%20option%20in%20connection%20properties%20but%20this%20only%20seems%20to%20impact%20refreshing%20the%20data%20model%20with%20the%20source%20data%20rather%20than%20changes%20to%20the%20data%20model%20itself.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20also%20tired%20setting%20the%20calculation%20mode%20in%20Power%20Pivot%20to%20manual.%20But%20that%20doesn't%20seem%20to%20stop%20the%20model%20recalculating%20when%20I%20make%20a%20change.%3CBR%20%2F%3E%3CBR%20%2F%3EHelp!%20This%20is%20eating%20up%20hours%20of%20my%20day%20at%20the%20moment.%20Excel%202013%20had%20an%20option%20to%20right%20click%20any%20pivot%20table%20and%20disable%20auto-refresh%20but%20I%20can't%20seem%20to%20find%20anything%20equivalent%20in%20the%20O365%20version%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2937914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When I update the data model in Power Pivot with a new calculated column or a new measure, excel automatically refreshes all the pivot tables in the file. This takes more than 2 minutes per change. How do I disable this feature? I have disabled the 'Refresh this connection on Refresh All' option in connection properties but this only seems to impact refreshing the data model with the source data rather than changes to the data model itself.

I have also tired setting the calculation mode in Power Pivot to manual. But that doesn't seem to stop the model recalculating when I make a change.

Help! This is eating up hours of my day at the moment. Excel 2013 had an option to right click any pivot table and disable auto-refresh but I can't seem to find anything equivalent in the O365 version


0 Replies