Or you could take 30 seconds to open a new workbook, enter

=Sheet2!A1

in Sheet1, cell A1. Then, in the VBE's immediate window, enter

Sheet2.Name = "newname"

Exit the VBE and verify that Sheet1!A1 now reads

=newname!A1

In article ,
JBW wrote:

I'll try it tomorrow when the date and hence the name chamges, I'm sure I
tried it before and excel went looking for the name as it had changed