PivotTable Does not refresh individual items
I have a pivot table connected to an external Access Table.
When I refresh, the overall totals and population update OK, but individual
page items somehow become misalligned. For example, if I set the page field
to "Asia" , it will show me totals for "Africa" and double-clicking on a data
item will produce a page showing records for, say, "Africa". Double-clicking
on a data-item when the page field is set for "All" will yield records that
include "Asia".
Anybody know what's going on?!
Cheers,
Nick
|