ExcelBanter - Pivot data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot data (https://www.excelbanter.com/excel-discussion-misc-queries/261124-pivot-data.html)

SCM

Pivot data

My Pivot is pulling in new items (row data) from my datasource when it
re-freshes. How can I keep row area static and pull in the new data only?

Gary Brown[_6_]

Pivot data

Using the row field dropdown, select ONLY the rows of data you would like to
see. When refreshing only those rows will continue to show.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

"SCM" wrote:

My Pivot is pulling in new items (row data) from my datasource when it
re-freshes. How can I keep row area static and pull in the new data only?

All times are GMT +1. The time now is 11:49 AM.