| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table - Preserve Formatting
Similar to other users I have been experiencing problems with preserving the
formatting on refresh in a pivot table. The "preserve formatting" option is selected and so too is the "enable selection". All fields are preserved with exception to one particular troublesome field. Does anyone have any further suggestions to resolve this issue? Kind Regards. |
|
#2
|
|||
|
|||
|
If the formatting suggestions from other posts haven't worked, you could
record a macro as you refresh the pivot table, and reformat the field. Then, run that macro as required. Ms MIS wrote: Similar to other users I have been experiencing problems with preserving the formatting on refresh in a pivot table. The "preserve formatting" option is selected and so too is the "enable selection". All fields are preserved with exception to one particular troublesome field. Does anyone have any further suggestions to resolve this issue? Kind Regards. -- 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 | |||
| Formatting of Pivot table | Excel Discussion (Misc queries) | |||
| format changes on pivot table although preserve formatting is che. | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
| Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
