What version of Excel are you using?
Is the data in the same workbook?
Do the field names change?

Mike W wrote:
When I refresh my pivot table, either manually or via code, all the fileds
vanish. Not the values but the table itself goes back to where I have to
place the fields in the table again.

Is there something I need to do to keep the formatting for the table?

Thanks,

Mike


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html