Updating pivot tables

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Updating pivot tables

Post by BittenApple »

Hello team,
When I come to update a pivot table that I have inherited, it says I don't have access to source data. I wonder if I can update pivot table this way.

Regards,
BlueTan

User avatar
HansV
Administrator
Posts: 78231
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Updating pivot tables

Post by HansV »

Click anywhere in the pivot table.
Activate the PivotTable analyze tab of the ribbon.
Click the 'Change Data Source' button in the Data group.
What does the dialog tell you?
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Updating pivot tables

Post by BittenApple »

Hello Hans,

Thanks for the response. It says data source is in appdata/ .... I don't have access to that folder.

bitten

User avatar
HansV
Administrator
Posts: 78231
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Updating pivot tables

Post by HansV »

In File Explorer. select View > Options.
This activates the Folder Options dialog.
Activate the View tab.
Under 'Hidden files and folders', select the option 'Show hidden files, folders and drives'.
Click OK.

S0794.png

Can you access the folder now?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Updating pivot tables

Post by BittenApple »

Hello Hans,
Thanks for the response.
Let me see, I will get back to you soon.
Bita

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Updating pivot tables

Post by BittenApple »

Hello Hans,
I hope you are doing well.

Still, I can't see the source of data. In the pivot table, change the data that you want to analyze: select a table or range: I can see a path to a folder which belongs to my boss and I don't have access to it.
Thanks for your time and your answer.

Bita

User avatar
HansV
Administrator
Posts: 78231
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Updating pivot tables

Post by HansV »

In that case, you won't be able to update the pivot table. That is only possible if you have access to the source data. You can't just wave a magic wand to update from data you cannot access.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Updating pivot tables

Post by BittenApple »

Hello Hans,
Thanks for clarification.
Bita