Thread: Pivot data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
 
Posts: 126
Default 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?