Pivot Table Formatting

[John Calder]

Hi

I run WinXP with Excel 2000.

I have a pivot table that uses data that is formatted in non-proportional
fonts (ie: Courier New). The pivot table is also formatted to
non-proportional fonts (Courier New)

I have the pivot table properties set to "Preseve Formatting"

When I close the spreadsheet and open it again, some of the fonts in the
pivot table revert to proportional fonts. I then have to reformat the fonts
back to Courier New

Is there anywaht I can stop this from happening?

Thanks

John

 

[John Calder]

For anyone who is interested I seem to have fixed the problem. Originaly I
was only formatting the actual pivot table. I found that by formatting the
each entire column (all the way down to the bottom of the worksheet) in the
pivot table that the formatting seems to stay put.

Hope this helps anyone with a similar problem.


JOHN

 

[Debra Dalgleish]

Another method that should work for you:

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings
Format the selected headings