Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

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.

Re: change pivot table data source

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 :-)

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.