Where is the column header you're referring to?

Is it in the source table, or is it iin the area where your pivot table is?

If it's the latter--refreshing the pivot table essentially is similar to
copying and pasting on top of the old pivot table. Make sure your column
header is outside the range used by the pivot table and you should be set.

If it's the former, then I haven't a clue.

Dave
--
Brevity is the soul of wit.


"Wes" wrote:

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