Thread: preserve formatting option in pivot table option dialog box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default preserve formatting option in pivot table option dialog box
If you don't have that option checked, some of the pivot table
formatting may be lost when you refresh the pivot table.

Dave F wrote:
Anyone know what the "Preserve formatting" checkbox does in the pivot table
dialog box? I was just asked this by a colleague and I have no clue....




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote