Don’t Make This Common Pivot Table Mistake

One of the biggest mistakes new Pivot Table users make is not including new rows and columns of source data in their Pivot Tables.

Thankfully there is an easy solution. It’s as simple as formatting your source data as an ‘Excel Table’.

Keyboard shortcut Create Excel Table in Microsoft Excel

When you format your Pivot Table’s source data as an Excel Table, it automatically expands to include new rows and columns as they are added, so you don’t have to repeatedly update your source data’s cell reference.

To format your source data as an Excel Table, click any cell in the data and press CTRL+T (or from the Home tab click Format as Table or from the Insert tab, click Table).

As with all Pivot Tables, you will still need to hit (right-click) Refresh to update your Pivot Table with the added data.