In Excel 2003, I have a pivot table linked to an Access database. How can I
determine the location of the database from within Excel? When I use the
Pivot Table Wizard, the "Get Data" button skips the location of the file and
immediately asks me which fields I want to import.
Bookmarks