Pivot Table
Hippopotomonstrosesquipidelian title
Join Date: Oct 2006
Location: is everything
Posts: 1,826
Likes: 0
Received 0 Likes
on
0 Posts
In the pivotchart wizard, select "multiple consolidation ranges" when asked "where are the worksheet ranges you wish to consolidate". You can then select ranges in different spreadsheets. The feature has changed names a couple of times.
Hippopotomonstrosesquipidelian title
Join Date: Oct 2006
Location: is everything
Posts: 1,826
Likes: 0
Received 0 Likes
on
0 Posts
The answer is still in #2.
Assuming you're already used to pivot tables, simply include the filename using the form [filename]sheetname!range rather than sheetname!range
Assuming you're already used to pivot tables, simply include the filename using the form [filename]sheetname!range rather than sheetname!range