All solutions Data SourcePIVOT TABLE Expert Solution – How to Change Pivot Table Data Source

Excel - How to Change Pivot Table Data Source - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Sir, I want to change the data source of my pivot table to another data source in another spreed sheet, how can I go about it in Google spreed sheet? Thanks
Solved by S. C. in 48 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/02/2018 - 04:06
Welcome to Got It Pro
Excelchat Expert 15/02/2018 - 04:06
Can you Please Upload your Document Here
Excelchat Expert 15/02/2018 - 04:08
Are you there ?
User 15/02/2018 - 04:08
Yes
Excelchat Expert 15/02/2018 - 04:08
Please upload your Document here
Excelchat Expert 15/02/2018 - 04:08
For a General Solution to your Question:
Excelchat Expert 15/02/2018 - 04:08
Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
User 15/02/2018 - 04:09
the document is in google drive cloud
Excelchat Expert 15/02/2018 - 04:09
Please make it shareable for public and share the link here
Excelchat Expert 15/02/2018 - 04:11
Are you there?
User 15/02/2018 - 04:11
https://docs.google.com/spreadsheets/d/1xpAklBL1Tfln0q4nMZSgNqlMJpPDnctxqR2Wg9C1FUM/edit?usp=sharing
Excelchat Expert 15/02/2018 - 04:12
In which Sheet is your Pivot Table present ?
User 15/02/2018 - 04:12
sheet 33
Excelchat Expert 15/02/2018 - 04:13
You mean sheet name "Pivot Table 33" ?
User 15/02/2018 - 04:13
YES
Excelchat Expert 15/02/2018 - 04:14
Ok
Excelchat Expert 15/02/2018 - 04:14
Can you explain your question a bit more? I'm checking your Document
User 15/02/2018 - 04:18
I intend to make a pivot table for all the sheets, I would like to use the pivot table of 33 and change the data source to that of the other sheet. this will save me time and I would not have start all from the begining
Excelchat Expert 15/02/2018 - 04:18
I will recommend you downloading your Google sheet file and Open it on Excel
Excelchat Expert 15/02/2018 - 04:19
After you make Changes in it, Save it and Upload it again on Google Cloud
Excelchat Expert 15/02/2018 - 04:19
Changes Procedure as Followed
Excelchat Expert 15/02/2018 - 04:21
Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
Excelchat Expert 15/02/2018 - 04:21
[Uploaded an Excel file]
Excelchat Expert 15/02/2018 - 04:22
Click Analyze > Change Data Source.
User 15/02/2018 - 04:27
Sir, are you still there?
User 15/02/2018 - 04:33
Thanks very much Sir, I will follow your instructions.
Excelchat Expert 15/02/2018 - 04:53
[Uploaded an Excel file]
Excelchat Expert 15/02/2018 - 04:53
In the Table/Range box, enter the range you want to use.
Excelchat Expert 15/02/2018 - 04:53
[Uploaded an Excel file]
Excelchat Expert 15/02/2018 - 04:53
This way you will be able to change your Data Source

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc