View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default preserve formatting option in pivot table option dialog box

That would make sense, thanks.
--
Brevity is the soul of wit.


"Debra Dalgleish" wrote:

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