change pivot table data source


Posted by Michael Bond on December 10, 2000 3:28 PM

how can i change the data source in an excel 2000 spreadsheet? i'm connecting to an access 2000 database.



Posted by marbel on December 11, 2000 11:30 AM

Go to the wizard and hit "back." change the source, and hope that the field names stick :-)