Under Pivottable options, turn off Autoformat table.
--
Kevin Vaughn


"Kathie" wrote:

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?