Pivot table to use other workbooks for data

E

Endorphin

Board Regular
Joined
Oct 27, 2006
Messages
62
Hi All,

Is it possible for an Excel Pivot table to use multiple workbooks & sheets as its data sources?

Neil
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
yes, in your pivot table wizard...select "external source data"...then push "get data" and browse to the other file
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Create pivot table using VBA?
Replies
4
Views
170
TheWennerWoman
T
L
  • Question
Refreshing Pivot tables *after* data table upon opening workbook
Replies
0
Views
518
Ludwig
L
I
  • Question
Create Pivot Chart without Pivot Table
Replies
0
Views
483
isntdoris
I
U
  • Question
Copy Paste Pivot Tables
Replies
7
Views
310
Alex Blakenburg
A
S
  • Question
VBA or Slicer / Power Query - Is it possible to select pivot table fields (column headers)
Replies
1
Views
479
Sheila8659
S

Forum statistics

Threads
1,207,170
Messages
6,076,912
Members
446,240
Latest member
theprattipati

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top