Dynamic pivot table linked to dynamic excel spreadsheets

F

FErd

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with multiple dependent excel spreadsheets 0
Pivot Table Macro with dynamic source data 1
Pivot Table from linked spreadsheets 1
DYNAMIC RANGE FOR PIVOT TABLE 1
Link Table to Excel Dynamic Named Range? 0
Excel 2007 pivot table: select multiple data easier 0
Dynamic formula for Pivot Table 6
Excel Pivot Table How to Sort data as Percent of Row 6

Top