(sometimes we provide two download links because it may happen that the main server / link is overloaded or slow or non responding - the files are identical. Just choose one, save to the Desktop, double click to install)
Disclaimer: to our best knowledge this download comes from a website that is
safe (the last time we checked it, it was), but for your peace of mind (and better safe than sorry) we advise you to run an
antivirus on the downloaded file. Do not rely on MSWindows, Internet explorer, or on the electronic signature: a unsigned download is usually as safe as a signed one, signed just means the author paid Microsoft or Verisign for a stamp, it does not mean verified. Please kindly
report us problems with detail (click here to report), if any.
Pivot Table AutoFormat XL is an Excel add-in that allows you to save pivot table formatting and to use it as a format template for your future pivot tables. The add-in remembers formatting of each pivot table area including page, row, column, and data fields and stores all format options such as number format, borders, patterns, alignment, and fonts.
It works efficiently in the Tabular mode and the Outline mode on MS Excel 2000, XP and 2003.
(
An add-in saves pivot table formatting and uses it as a format template.)

Pivot Table AutoFormat XL allows you to save pivot table formatting and to use it as a format template for your future pivot tables.
Pivot Table AutoFormat XL 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
Pivot Table AutoFormat XL stores:
- Number formatting
- Borders
- Patterns
- Alignment
- Fonts
Pivot Table AutoFormat XL works efficiently with pivot tables in the Tabular mode as well as in the Outline mode.
As well as the built-in AutoFormat, Pivot Table AutoFormat XL is designed for formatting your pivot tables. But unlike the built-in AutoFormat, Pivot Table AutoFormat XL:
- 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.
Pivot Table AutoFormat XL 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.
Pivot Table AutoFormat XL is an add-in for Microsoft Excel 2000, 2002 and 2003.
pivot table autoformat software, pivot table format software, pivot table software, excel software, add in software