View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FErd FErd is offline
external usenet poster
 
Posts: 2
Default 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