Often it happens to have to create a PowerPivot model complex as logic and calculations , and as we know every time we make a change to the data model or to a measure that will be set to calculate the entire sheet and all associated pivot tables .
Quite annoying if the model takes 1 or 2 minutes each time . A good solution identified online is to install an add-on , I have tested it on excel 2010 2013 and by problems .
Just downloaded the rar file you just install it ( I recommend you close all excel before it goes in the conflict ) . Now reopen your Excel and then open the model , at this point, just select any pivot table and click with the right mouse button . If the installation is correct you should see the ” Disable auto refresh ” button at this point will be enough to select and work on the data model .
Complete the activities just close pivot power redo right on the times table before and reactivate the auto refresh . At this model will calculate and update all changes made within the various tables and pivot charts . and that’s it
C