View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Pivot Table Refresh

If I Apply an auto-filter to the data-source of my Pivot Table
It does not effect to refreshed results of my PT.

Can someone confirm this -- that is from a Pivot table data-sources
records - any hidden rows (from an auto-filter) do not get omitted.
The PT uses ALL record, Hidden or not..
TIA,