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?

Excel 2007 - how to do PivotTable on filtered, visible data only?
 

Excel 2007 PivotTable
Pivot filtered Table data.
http://www.mediafire.com/file/jlmmnr...11_03_09a.xlsm