Ruth J wrote:
Problem: Sheet2 links sometimes change due to the way the Master is
refreshed. I need to make the links absolute in all 1400 rows. Is there an
easy way to do this other than cell by cell


Making them absolute may well not be the solution.
If the method of refresh doesn't result in Sheet1!A1 moving or being deleted
then the following would be give a link from Sheet2!whatever to
Sheet1!whatever:

=OFFSET(Sheet1!$A$1,ROW()-1,COLUMN()-1)


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup