AutoFormat for Microsoft Excel PivotTables allows you to save pivot table formatting and to use it as a format template for your future pivot tables.
AutoFormat for Excel PivotTables remembers formatting of each pivot table area:
Page fields area
Row fields area, including subtotals, blank lines and first rows
Column fields area, including subtotals
Data fields area
Common pivot table areas, including row and column grand totals
AutoFormat for PivotTables works efficiently with pivot tables in the Tabular mode as well as in the Outline mode.
As well as the built-in AutoFormat, AutoFormat for Excel PivotTables is designed for formatting your pivot tables. But unlike the built-in AutoFormat, AutoFormat for Excel PivotTables:
Creates and applies your own formatting templates.
Doesn't change the layout of your pivot table. You can be sure that fields are not moved between pivot table areas and nothing is added to or removed from your table.
Allows you to apply several format templates to one pivot table. You can combine format templates to your liking.
Saves and restores formatting of each pivot table area, even when the pivot table layout was changed.
Supports export of format templates to other PCs.
Supports import of format templates from other PCs.
Allows you to group format templates.
AutoFormat for Excel PivotTables just formats pivot tables. If you pass somebody the workbook that contains the pivot table formatted by AutoFormat XL, do not worry. This table will have the same look as yours. And it is not necessary for your correspondent to have AutoFormat XL installed.
AutoFormat for Excel PivotTables is an add-in for Microsoft Excel 2007, 2003, XP (2002), and 2000.
ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...