Forum Discussion
Pivot Table Refresh Issues
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
- BootsyDarlin
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
If you convert the source range to a table (Insert tab of the ribbon > Table), it should work.
