Dynamic pivot table linked to dynamic excel spreadsheets
 

Hey,

Is it possible to create a dynamic pivot table (dependent) that has a
relationship to multiple dynamic excel spreadsheets (source's)?

Each (source) spreadsheet is formatted identically to one another.

I want to be able to add more data to the sources and have the pivot table
update in relation to the changes that are made.

FErd

--
Frildo Andersen
CARE Hawaii, Inc.
606 Coral St. 2nd floor
Honolulu, HI 96813
phone: 808-791-6159
fax: 808-791-6198