I have an Access 2000 pivot table form and I want to add a new fld or change the name of an existing field in the record source table (which is built dynamically with a make table qry), but when I do, neither the new or changed field names are reflected in Excel 2000 as available to add to the pivot table. How do I get these field changes to pass through without recreating the whole pivot table form?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access pivot table rec source fld changes don't carry over to Excel
- Thread starter lgbatdw
- Start date
Similar threads
