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
|