pivot tables not refreshing correctly

[Tom G.]

the data in my pivot tables are not updating correctly - the rows update
correctly, but the data items do not.

I sometimes have to exit and re-enter the spreadsheet after performing the
refresh data command in the pivot table.

any suggestions?