Yup, indeed the rename isn't working. It does work as expected with a globally defined name, but that doesn't solve your problem I guess.

I guess your workaround will need to be to either not use local named ranges in hyperlinks, or to rebuild the hyperlinks. Sorry, not much help I guess.