How to make pivot table get newly added rows

[steveski]

I have a data entry sheet and a pivot table sheet. When I add new rows to the data entry sheet the pivot table does not automatically incorporate the new data. Is there a way to make the pivot table automatically incorporate newly added rows?

Thanks

 

[PaddyD]

hi - welcome to the board!

you need to define the pivot range as a dynamic named range that will update as new rows are added - plenty of examples on the board - do a search, post back with more detials if you can't get it working.

 

[steveski]

Thank you, that worked. Should I close this thread?