software

How do I retain or change the default column setting to retain my formatting
on refresh? I did change the options on the pivot to retain formatting and I
have an auto format report, but each time I refresh the column formatting
reverts back to wide cols. Is there a default that I can change?

Under Pivottable options, turn off Autoformat table.
--
Kevin Vaughnquot;Kathiequot; wrote:

gt; How do I retain or change the default column setting to retain my formatting
gt; on refresh? I did change the options on the pivot to retain formatting and I
gt; have an auto format report, but each time I refresh the column formatting
gt; reverts back to wide cols. Is there a default that I can change?

If you're using a pivot table AutoFormat, that includes column widths,
so when you refresh, the adjustments that you made are removed.

You could record a macro as you refresh the pivot table and adjust the
column widths. Then run that macro as required.

For information on macros, see David McRitchie's site:

www.mvps.org/dmcritchie/excel/getstarted.htm

Kathie wrote:
gt; How do I retain or change the default column setting to retain my formatting
gt; on refresh? I did change the options on the pivot to retain formatting and I
gt; have an auto format report, but each time I refresh the column formatting
gt; reverts back to wide cols. Is there a default that I can change?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html