I am trying to refresh an existing pivot table whose data source is in a different tab. The number of rows in the data source are not constant and can change. How do i change the data source to select the complete range before refreshing the Pivot table.
I do not have any coding experience and would highly appreciate any inputs on the above. Thanks in advance for your help.