Automatic updating pivot table

Rated 4.16/5 based on 777 customer reviews

The recording is now completed and you have to turn off the macro recorder by clicking the Stop Recording control in the Macros group on the View tab.

You record a macro of your refreshing the Pivot Table and then you copy the recorded code and paste it into one of the worksheet’s events.Make sure that the Store macro in: setting is This Workbook and click the OK button.Now you have to record your refreshing the Pivot Table; just right-click the active cell and choose Refresh from the shortcut menu.In the screen shot below, In Excel 2007 and later versions, you can format your list as a Named Table, and use that as the dynamic source for your Pivot Table.There are detailed instructions here: Excel Tables -- Creating an Excel Table.

Leave a Reply