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 ...
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.
- OK, Thanks for the help !!
