Forum Discussion
Excel Update Pivot Table Source Not Working
Folks, I'm adding Pivot table source update comment in case others have the same problem. Problem I created a pivot table whose source data changed because I added rows to the source. When I ...
Working with data model you may select to change connection properties
and here change the range on another one
Even better to work with tables or named ranges.