Pivot Table vanishes when refreshed

  • Thread starter Thread starter Mike W
  • Start date Start date
M

Mike W

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
 
What version of Excel are you using?
Is the data in the same workbook?
Do the field names change?
 
Back
Top