Connecting a Pivot Table to another Existing Workbook
http://www.ReportingGuru.com produced this video. This video shows how to connect a Pivot Table to another existing worksheet. Email us at [email protected] if you need help, custom reports, or reporting architecture setup.