mellifluous
New Member
- Joined
- Jun 3, 2015
- Messages
- 3
Hey guys,
I've had a hunt around and I know there are some really good Name Manager solutions, but my one is a little bit strange.
I have a lot of duplicate names in the Name Manager.
This was from a rebuild when some LiveOffice components stopped working.
When I delete the Name Manager duplicates, a lot of my cells come back with #REF! even though I have correctly pointed the name range to the relevant cells.
So I can't seem to replace the Names like for like in the Name Manager and have the cells update automatically.
For example if I have several names called "SAUSAGESANDMASHNUMBERS" and that refers to cells A1 to A5 on a deleted sheet in the workbook and then I delete the duplicates and point that name to refer to A1 to A5 on the new sheet, the cells that I have that use the SAUSAGESANDMASHNUMBERS as a range in a formula now return #REF!
Would really appreciate any help / shortcuts. At the moment I'm correcting them all manually and this is likely to take a couple of weeks at this rate!

Thanks so much
M
I've had a hunt around and I know there are some really good Name Manager solutions, but my one is a little bit strange.
I have a lot of duplicate names in the Name Manager.
This was from a rebuild when some LiveOffice components stopped working.
When I delete the Name Manager duplicates, a lot of my cells come back with #REF! even though I have correctly pointed the name range to the relevant cells.
So I can't seem to replace the Names like for like in the Name Manager and have the cells update automatically.
For example if I have several names called "SAUSAGESANDMASHNUMBERS" and that refers to cells A1 to A5 on a deleted sheet in the workbook and then I delete the duplicates and point that name to refer to A1 to A5 on the new sheet, the cells that I have that use the SAUSAGESANDMASHNUMBERS as a range in a formula now return #REF!

Would really appreciate any help / shortcuts. At the moment I'm correcting them all manually and this is likely to take a couple of weeks at this rate!


Thanks so much
M