View Single Post
  #4   Report Post  
Andy Brown
 
Posts: n/a
Default

Is there any way to "lock" the formatting in a pivot table?

There's a way to "unlock" the standard formatting. Rightclick a cell of the
table, select "Wizard". Click "Options", *un*check "AutoFormat Table". Click
OK & Finish.

Rgds,
Andy