Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets

Hacks #46-49

Section 45.   PivotTables: A Hack in Themselves

Section 46.   Share PivotTables but Not Their Data

Section 47.   Automate PivotTable Creation

Section 48.   Move PivotTable Grand Totals

Section 49.   Efficiently Pivot Another Workbook's Data