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.