Thread: Excel 2007 - how to do PivotTable on filtered, visible data only?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ZMAN ZMAN is offline
external usenet poster
  
Posts: 3
Default Excel 2007 - how to do PivotTable on filtered, visible data only?
Is there anyway to run a Pivot on filtered data only so that the
outcome will not use the entire spreadsheet to calculate the table but
only the visible data that is filtered?
Reply With QuoteReply With Quote