Prev: Pyramid Charts
Next: How do I keep formatting when creating a chart from a pivot?
From: JimHawkins on 14 May 2010 19:43
I can't seem to maintain any formatting after I refresh the pivot table.

I'm using Access 2007.
From: trip_to_tokyo on 15 May 2010 05:18
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.
 | 
Pages: 1
Prev: Pyramid Charts
Next: How do I keep formatting when creating a chart from a pivot?