I'm tearing my hair out with this one.

I have a workbook containing 3 named ranges.
A macro in another workbook opens the workbook with the names in it, does some stuff then saves the opened wb with range names, with another file name.

When I open the newly named file two of the range names are still there but the third has disappeared.

Any suggestions anyone?

Usual TIA