View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
overjaxed overjaxed is offline
external usenet poster
 
Posts: 1
Default pivot table; adding kolomns to the base-table afterwards

Hi,

I have a MS Access database table (actually a query view on a table)
I use this as data source for some pivots

The problem:
I have extended the query so it contains some extra fields, but those
fields do not show in the PivotTable fields list. Does anyone know the
trick? I have tried to refresh the data, saved and reloaded the
excell, but this does not help.

Thanks in advance!