Pivot Table Forms (Access 2000)

Topic

New Reply

I have a Pivot Table form based on a query. I have added some additional fields and can see them on the field list. However they don’t seem to want to get on to the toolbar in Excel! I have tried refreshing the query to no avail.

Other than creating a new pivot table form has anyone any idea of how i can get the pivot table in excel to recognise there are some more fields available?

Thanks

Reply | Quote

Replies

I believe the only way to update the pivot table to pick up the additional fields is to re-create the pivot table form with the new fields selected. I believe there were some other posts regarding this as well.

Reply | Quote