Thread: URGENT! Retain format of cells in pivot table upon refresh
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dls61721 dls61721 is offline
external usenet poster
  
Posts: 9
Default URGENT! Retain format of cells in pivot table upon refresh
Right Click in Pivot Table
Table Properties
Preserve Formatting

"KDG" wrote:

I would like to retain the format of the cells (I want the alignment and
column width to remain the same) when I refresh the pivot table. Each time I
refresh the formating goes back to the default setting. Is there a way to
lock the format of the sheet and still be able to refresh the data?
Reply With QuoteReply With Quote