I have a fairly large and complicated Excel workbook that I have been developing and modifying over the years.  For quite a long time it often showed messages about random chart settings when the cursor was hovering over a blank area.  It recently started to fail to populate a chart with cell refences to another worksheet within the workbook.  I took this as a bad sign and decided to remake the entire workbook by copying and pasting each worksheet from the original workbook into the new workbook.  i then broke all the links to the old workbook in the new workbook and CTRL-H'd the old workbook name with a bland.

Now all the source data for the charts look good, but don't work - no data appears in the charts.  To get the data in I now have to edit each Y value reference manually.

Because there are a lot of cell references in the formulae in the workbook, I'd really like to find a way to re-activate all the cell references automatically.  I can't find a way io do this.  I would be grateful for any help.

Thank you