Pivot Table problems Excel 2002
 

I have several spreadsheets that contain pivot tables. I refresh them by
name using VBA macros. I've had the spreadsheet lose all knowledge that the
information in a worksheet is a pivot table. It looks like a pivot table but
must be recreated and renamed before the spreadsheet and excel recognizes it
as such. This is an intermittant but annoying problem. I'd appreciate any
suggestions on what to look for with this problem.