formatting on a pivot report refresh
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? |
formatting on a pivot report refresh
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? |
formatting on a pivot report refresh
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: http://www.mvps.org/dmcritchie/excel/getstarted.htm 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 11:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com