View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick O[_2_] Nick O[_2_] is offline
external usenet poster
 
Posts: 8
Default 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