Column in Chart references current date for a block in data spreadsheet with formula (=@CONDA)

Copper Contributor

Not that familiar with Excel. I'm trying to edit a chart from a previous employee.

First page is a chart with data references from page 2.

I've figured out how the chart works, but not the current date data.

 

Fx shows "=@CONDA"  for one of the blocks

4 Replies

@Rich_Cranium 

On the Formulas tab of the ribbon. click Name Manager.

Is CONDA listed there? If so, select it and inspect the 'Refers to' box.

Thanks. That tells me what I needed.
Can I change the Name without affecting the formula function ?

@Rich_Cranium 

If you edit a defined name, all formulas using that name will be updated automatically.