Aug 16 2022 05:38 AM
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
Aug 16 2022 06:11 AM
On the Formulas tab of the ribbon. click Name Manager.
Is CONDA listed there? If so, select it and inspect the 'Refers to' box.
Aug 16 2022 06:15 AM
Aug 16 2022 06:20 AM
If you edit a defined name, all formulas using that name will be updated automatically.
Aug 16 2022 06:24 AM