View original (French)

Unable to refresh data (Excel 2010)

Solved
Mots croisés Posted messages 3059 Registration date   Status Membre Last intervention   -  
Mots croisés Posted messages 3059 Registration date   Status Membre Last intervention   -
Hello,

I have a workbook that contains 3 sheets.

The last sheet contains the pivot table (copied from another workbook).
I then enhanced this pivot table.

Now I have a problem, this message (that you see) informing that it is impossible to open the source file.

I don’t understand this impossibility. This sheet is no longer linked to its original workbook.

If anyone can help me understand and resolve this issue.

Thank you

https://www.cjoint.com/c/ELvoTmajhje

Configuration: Windows / Firefox 43.0

--
Without the Helpers, our computer wandering would be endless - Crosswords

1 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello

your copy-paste probably created links with the original file of the pivot table
I don't know 2007 but there is in the data tab of 2007 a section "connections" with a line "edit links" that allows you to remove links with external files

best regards

--
To err is human, to persist is diabolical
0
Mots croisés Posted messages 3059 Registration date   Status Membre Last intervention   113
 
Hi Vaucluse.

I'm looking to see if I can find something like that.
0
Mots croisés Posted messages 3059 Registration date   Status Membre Last intervention   113
 
So if you're still there, here's what I did.

I've been fiddling around a bit, but I can't see at all what connects this sheet to the other workbook (which I actually deleted).

What I did. I recreated a pivot table AND NOT a pivot chart, which I positioned in the same place as the previous one (under the chart that I kept).

So you can still use the screenshot that hasn't changed.

So my question now.

Is it possible to link the data from the pivot table to the chart that you see in the screenshot?

It would save me from having to recreate a complete pivot chart.
0
Mots croisés Posted messages 3059 Registration date   Status Membre Last intervention   113
 
I've found Vaucluse.

I'll explain the process in case someone is interested.
I want to clarify that the Pivot Table and the chart (at the beginning) are not linked at all.

So, I select the chart, the "PivotChart Tools" toolbar appears.
In the "Data" tab, click on "Select Data". And when the window appears, click "OK".
And from then on, the chart and the Pivot Table are linked.

This process worked for me.

See you later Vaucluse, thanks
0