Data Source of Pivot table

R

Reiner Harmgardt

Hi NG

if i create a Pivot table with the Wizard in Excel 2000 and have my data in
a ACCESS 97 table,
where can i see the explicit Path and name of the database and the table
that are concerned.

if the place of the database changes, is it possible to write this change
directly into to excel-File
via VBA to tell him, that the refresh has to be taken from a different
database.

maybe the access-table-name could be changed also, on the bassis, that the
structure stays the same.

Thanks for helping

Regards

Reiner
 
Top