I’m using Office 365’s Excel 2016 (desktop), but these tips apply to earlier versions. You can refresh single ... have to save the pivot table to the data model when you create it as follows ...

Here, we show you how to create a pivot ... way to do this is to use Excel tables, which let you add rows that will be included with your pivot table whenever you hit refresh.