Forum Discussion

Copper Contributor

Oct 03, 2021

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...

excel

HansVogelaar
Oct 03, 2021
Djoelle

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.

HansVogelaar

MVP

Oct 03, 2021

Djoelle

If you click on the shape, what formula do you see in the formula bar?

Djoelle

Copper Contributor

Oct 03, 2021

Hi there HansVogelaar ,
When I click on the shape this is the formula =$B$4

HansVogelaar
MVP
Oct 03, 2021
Djoelle

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.
- Djoelle
  Copper Contributor
  Oct 03, 2021
  It worked. I really appreciate your help. Thank you HansVogelaar !!
  - HansVogelaar
    MVP
    Oct 03, 2021
    Djoelle
    
    You're welcome!