Hi,

I have a table in an Excel 2008 file that is pulling data from an Access database query. I then have a pivot table that is using that table as it's source data. I just opened my file after not looking at it for a while and went to refresh my pivot table. When I do that, all of the data disappears and I am left with my grand total line showing all zeros. I tried to change the source of the pivot table and re-set it to the same source table, and it retains the data. But if I try to refresh it again, it all goes to zero again.

Please help me!

Dana