If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot table formatting removed/lost/reverted upon refresh
I can't seem to maintain any formatting after I refresh the pivot table.
I'm using Access 2007. |
#2
|
|||
|
|||
Pivot table formatting removed/lost/reverted upon refresh
EXCEL 2007
Try the following:- 1. Right click somewhere in your Pivot Table and select PivotTable Options . .. . 2. The PivotTable Options window should launch / Layout & Format tab / remove the tick (check) from Autofit column widths on update / OK You might also try, if you have lost formatting, re-applying it quickly by clicking in the Pivot Table / PivotTable Tools / Design contextual tab / PivotTable Styles group / clicking one of the styles in here will format your Pivot Table quickly. If my comments have helped please hit Yes. Thanks. "JimHawkins" wrote: I can't seem to maintain any formatting after I refresh the pivot table. I'm using Access 2007. |
Thread Tools | |
Display Modes | |
|
|