Text Box linked to a cell showing data from a Pivot Table

[Mozil]

Good day

I have created a few text boxes to show values from a Pivot Table, I linked (GETPIVOTDATA) the Pivot Table values to separate cells.
I then linked these cells to the text boxes. I added a slider to filter per month and all works perfectly.

As soon as I save, close and then re-open the worksheet the text boxes no longer change with the sliders whereas the cells linked to the pivot table still change their values.

 

[vletm]

Mozil
As You've read from Forum Rules ...
Please, send a sample Excel-file, which shows Your case.
Without it - other could guess guess ...
You're writing about a Pivot Table ... or do You mean Power Pivot?

 

[Mozil]

Hi @vletm

Thanks for the reply, please see attached. I have done an example of the issue I am experiencing.

Tab 1 is the pivot table, tab 2 is the data and tab 3 is where text boxes are that I am having an issue with.

Difficult to show through the attached what my issue is but prior to saving and closing this file the values in the text boxes would change along with the slicer below them. I have also outlined the cells where the Text box values are supposed to pull from.

 

[vletm]

Mozil
Do You mean something like below?
You're selecting those two dates ...
>> The 1st value is Okay and other two values (for 2 & 3) are #REF! <<

... because Your Pivot-table has values for 1, 7 and 8.

and Your formula tries to show values for 1, 2 and 3.
I could save > close > open > and those seems to work as well as possible.

 

[Mozil]

Hi @vletm

The cells are fine, if you select the entire date range you will get values in the cells for 1,2 & 3.

The issue is the display of those values in the shapes / text boxes. If you had to re-link those shapes with the cells displaying the values they will change together with the slider, if you were to save, close and then re-open the file again those shapes / text boxes no longer change when you adjust the slider and only show the last values displayed when you closed the file.

 

[vletm]

Mozil
Why should someone had to re-link those shapes?
If selection is as below then - textboxes will show as below - okay?
You can see Your 2nd textboxes formula too.

After that - You'll save > close > reopen that file - okay?
You can see still same as above - okay?

Next, You'll select 29/04/1998 and
You'll see as below - okay?

Your formulas as well as everything else will works as You've 'told' to Excel.

Have You reread GETPIVOTDATA'a syntax?
If You would like to see something else then
You should explain to Excel - What should be work other ways?