Update only selected tables in your Excel Power Pivot Model
Here is a quick tip to update selected tables in your Power Pivot model instead of doing it one by one or via the “Refresh All” option.
If you switch to Diagram View and select the tables you want to update while holding the CTRL key – and then click Refresh – This will only update the selected tables.
In this case I have selected the Sales, Chain and Product table
And voila – 3 out of 6 tables updated
Hope this can save you some update time.