Forum Discussion
Solved
Excel Dashboard: Value from pivot table not appearing in linked shape
Hello, I am trying to create a dashboard in Excel and I am having issues with linking cell values to shapes. If I link a value to a shape on the same worksheet it works and is dynamic. But when...
When you copy a shape from one sheet to another, the formula doesn't change. So the formula now refers to cell B4 on the dashboard sheet. If the cell in the pivot table is on another sheet, you must edit the formula:
='Other Sheet'!$B$4
where Other Sheet is the sheet with the pivot table.
Hi there HansVogelaar ,
When I click on the shape this is the formula =$B$4
When you copy a shape from one sheet to another, the formula doesn't change. So the formula now refers to cell B4 on the dashboard sheet. If the cell in the pivot table is on another sheet, you must edit the formula:
='Other Sheet'!$B$4
where Other Sheet is the sheet with the pivot table.
It worked. I really appreciate your help. Thank you HansVogelaar !!
You're welcome!