Pivot Table- Link internal to external connection

J

JVID720

New Member
Joined
Jun 11, 2015
Messages
9
Is it possible to link an existing pivot table to an external data source? I wanted to move the data out of the workbook but didn't want to redo my pivots.

JV
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
Can't you simply move the data to a new workbook, and then move the PivotTable to the same new workbook?
 
Upvote 0
Just to clarify what I mean by 'move', I mean right click on the sheet --> Move or Copy --> New Workbook or select from the list of open workbooks.
 
Upvote 0
Ben, Right now the data is sourced against excel data sheet but I want to source it against an access data base (via external connections). Am I over complicating this? Please tell me I am :)


John
 
Upvote 0
JVID720 said:
Ben, Right now the data is sourced against excel data sheet but I want to source it against an access data base (via external connections). Am I over complicating this? Please tell me I am :)


John
Click to expand...

Honestly, I don't know. Never used Access, and I didn't understand that from your question.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
pivot table external source
Replies
5
Views
658
alansidman
A
E
  • Question Question
Stumped Trying to Find a Table Referenced by Pivot Table
Replies
3
Views
384
Elfear73
E
D
  • Question Question
Pivot table filters
Replies
2
Views
420
dmfweb
D
A
  • Question Question
Take screenshots & simultaneously capture the link, place it into an Excel file which is linked to a FileMaker/Claris db.
Replies
3
Views
388
Dan_W
D
M
  • Question Question
remote pivot table
Replies
0
Views
249
MetLife
M

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

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