Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop an pivot report from losing conditional formatting | Excel Discussion (Misc queries) | |||
refresh pivot report | Excel Discussion (Misc queries) | |||
Pivot Chart Report - formatting | Charts and Charting in Excel | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) |