A table offers important advantages and makes working with pivot tables a lot easier.
Let’s take a look.
Here we have a worksheet that contains property listings.
Let’s quickly build a pivot table without using a table.
As you’re free to see, we get a pivot table on a new worksheet.
Now let’s add some additional properties to the data.
We’ll just paste the new listings at the bottom of the existing data.
Let’s refresh the pivot table.
Notice that the pivot table doesn’t change.
That’s because the new data isn’t automatically added to the pivot table.
We can fix this problem by choosing Change Data Source on the Ribbon.
Now let’s remove the pivot table, and the extra data we added, and retry.
This time, we’ll convert the data to a Table first.
Then change the table style if you like.
you’re able to also change the table name to something more meaningful, but this is optional.
Now let’s create the Pivot Table again.
We’ll accept the default parameters, then build our pivot table as before.
The results are the same.
Now let’s add the additional data and refresh.
This time, we see all 26 properties.
In addition, any new columns in your Table will appear as new fields in the pivot table.
