Can we create a Pivot Table from different workbooks

**dineshsachidananda** · 06-17-2014, 09:04 AM

For example...

I have data for monday.. Tueday ..Wednesday as individual excel

All the excel have same column names and dynamic values.

Is there a way i can create one pivot with different excel as source

**alansidman** · 06-17-2014, 09:07 AM

Here is a tutorial that should walk you through how to do that.

http://www.contextures.com/xlPivot08.html

Can we create a Pivot Table from different workbooks

LinkBack

Thread Tools

Rate This Thread

Display

Can we create a Pivot Table from different workbooks

Re: Can we create a Pivot Table from different workbooks

Thread Information

Users Browsing this Thread

Similar Threads

Excel 2007 : Pivot Chart/Table create a new drop down menu in existing table

Create multiple pivot charts from one pivot table

[SOLVED] Create Pivot Table: Cannot Open Pivot Table Source File

Create pivot table from exisiting pivot table

[SOLVED] How do I create multiple pivot charts from one pivot table?

Bookmarks

Bookmarks

Posting Permissions