Want Help Converting Excel Links to Named Cells (i.e. 1 cell Ranges)
 

I have a set of 40 legacy workbooks, with at least two sheets per
workbook, that link between sheets and workbooks. To facilitate their
maintenance when new rows or columns are added, I am Naming Cells (i.e.
Named Ranges). What I am looking for help with is once I've named
Cells, updating all workbooks Link references to use the Name instead
of the sheet, row, column reference.

Does anyone have a good solution for automating changing these Links?

Want Help Converting Excel Links to Named Cells (i.e. 1 cell Range
 

Try using the Insert / Name / Apply menu option.

"orangepips" wrote:

I have a set of 40 legacy workbooks, with at least two sheets per
workbook, that link between sheets and workbooks. To facilitate their
maintenance when new rows or columns are added, I am Naming Cells (i.e.
Named Ranges). What I am looking for help with is once I've named
Cells, updating all workbooks Link references to use the Name instead
of the sheet, row, column reference.

Does anyone have a good solution for automating changing these Links?