How can remove define names without #ref'ing out on existing formulas?

[cotatliad]

I received a complicated financial model and I am having hard time understanding it because of all the define names.

I can remove them from"name manager" in formulas tab but that the formulas referring to names stay unchanged and they all #ref out.

Is there a way to delete/remove all defined names in a spreadsheet without breaking existing formulas? Thank you very much!!

 

[Anthony47]

I don't know if you can remove the Names and still save the integrity of the formulas.
However I'd guess that the names are more meaningful than just cells coordinates, so their use should help in understanding the formulas, not make it more complex.
You can easily create the list of Names that exist in the workbook and their reference:
-select a cell in a free area of any sheet
-Menu /tab Formula /group Defined Names; click "use in a formula", Paste names, Paste list (**)
This should create a list of names and their associated area
Note**: this is my best translation of the terms, so look for something similar (non necessarily the same exact term).

Bye