View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Pivot Table Formatting

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