View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wes Wes is offline
external usenet poster
 
Posts: 26
Default PIVOT TABLE COLUMN

When I either refresh data or change my source data range for pivot table
(Excel 2003), it clears out the column header. I've read several answers to
this question, but I have made the following changes & it didn't help:
Check Preserve formatting
Remove check from AutoFormat Table
I even tried to change the Enable Selection

Nothing has worked. Please help! I really don't want to write a macro to
rebuild this each time. I've had enough frustration getting it to this
point. Thanks