links to pivot sheet cells do not hold the link
I have created a pivot sheet. I then from another sheet link a cell to the pivot sheet but the link does not hold. This just started happening with newly created pivot sheets.
I have a number of older pivot sheet created and the cell links are fine.
I also use pivot cell links in my dashboard metrics, they are now coming up with "missing data" for the metric.
Has anyone else experienced this?