pivot table; adding kolomns to the base-table afterwards

  • Thread starter Thread starter overjaxed
  • Start date Start date
O

overjaxed

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!
 
YOu need to redefine which fields the pivot table looks at. Bring up the
pivot table wizard and hit the Previous button to take you back to where Get
Data was defined. Hit Get Data and select the new fields you want for your
Pivot Table...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Pivot tables not refreshing after data source update 1
Pivot table drill down sort 0
Pivot Table Question 2
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Pivot Table Deconstruction 2
Pivot Table Refreshing 2

Back
Top