Howdie...

I have an existing workbook with many fully functional pivot tables.

I update the data in the workbook, request the pivot table to update
(refresh data) but it does not update.

If I recreate the pivot table - it does infact update. Problem is I have
many pivot tables, and I can see no reason for having to recreate
something that is already there.

If I use the pivot table wizard, I can confirm that the pivot table is
referring to the correct data.
Also if I look within the options of the pivot table field, (ie clicking
on the drop down arrow on the pivot table) it is showing many options
all ticked, but not displaying them in the body of the table?

Anybody get any general suggestions to fix...?

Thanks so much

Regards

Darin



*** Sent via Developersdex http://www.developersdex.com ***