Cannot change PivotTable Data Source

%3CLINGO-SUB%20id%3D%22lingo-sub-1605882%22%20slang%3D%22en-US%22%3ECannot%20change%20PivotTable%20Data%20Source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605882%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20Excel%20spreadheet%20with%20a%20pivotchart%20pointing%20to%20a%20specific%20data%20range%20in%20another%20workbook.%20This%20workbook%20does%20not%20exist%20anymore%20and%20we%20want%20to%20change%20the%20datasource%20to%20a%20tab%20in%20the%20same%20workbook%20as%20the%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20we%20open%20the%20Change%20PivotTable%20Data%20Source%20dialog%20(see%20picture%20below)%2C%20it%20shows%20the%20current%20table%2Frange%20like%20this%3A%3C%2FP%3E%3CP%3E'https%3A%2F%2F%26nbsp%3B%20xxxxxxxxx%26nbsp%3B%20%2Fsites%2F%20xxxxxxxxxxx%20%2FGedeelde%20documenten%2FOpdrachten%2F34.2%20programma%20Eenzaamheid%2F%5B200320_Concept%20database%20Eenzaamheid.xlsm%23BgEIDA4ADAMGBAcBBAQECw%3D7.0%5DInvoerveld_subsidieaanvragen'!%24A%244%3A%24DG%24105%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tdnooij_0-1598127094532.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214010i3A099943DE6C8AA2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22tdnooij_0-1598127094532.png%22%20alt%3D%22tdnooij_0-1598127094532.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(url%20obscured)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20we%20try%20to%20change%20this%20by%20selecting%20another%20range%20and%20click%20OK%2C%20nothing%20happens%20and%20the%20previous%20range%20is%20still%20used.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20how%20to%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

We have an Excel spreadheet with a pivotchart pointing to a specific data range in another workbook. This workbook does not exist anymore and we want to change the datasource to a tab in the same workbook as the chart.

 

When we open the Change PivotTable Data Source dialog (see picture below), it shows the current table/range like this:

'https://  xxxxxxxxx  /sites/ xxxxxxxxxxx /Gedeelde documenten/Opdrachten/34.2 programma Eenzaamheid/[200320_Concept database Eenzaamheid.xlsm#BgEIDA4ADAMGBAcBBAQECw=7.0]Invoerveld_subsidieaanvragen'!$A$4:$DG$105

 

tdnooij_0-1598127094532.png

 

(url obscured)

 

When we try to change this by selecting another range and click OK, nothing happens and the previous range is still used.

 

Any ideas on how to fix this?

 

0 Replies