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 goin...
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.
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
