Pivot Table Refresh Issues

New Contributor

So I have the data source for my Pivot Table set to columns A through I, but my table doesn't always refresh with new rows added to the bottom. Could I get some help on this, I'm not sure what's going on

3 Replies


If you convert the source range to a table (Insert tab of the ribbon > Table), it should work.

May be your new row didn't define in your pivot table range, so you have define new range in this way:
1- click on your pivot table-> "Analyze" tab -> select "Change data source"
2- the next way is you can select all column A as your range , after that filter blank cells.
I have all columns A through I as the range and blank cells are filtered