Forum Discussion
Column in Chart references current date for a block in data spreadsheet with formula (=@CONDA)
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
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 ?If you edit a defined name, all formulas using that name will be updated automatically.
