How to delete defined names without breaking formulae?

Hi,

I need to delete all names in a worksheet but when i do this all formulas that refers to those names stop working. They show a #NAME error.

How do I unapply/substitute names with the corrisponding cell references before deleting the names ?

Are there any (other) solution ?

Thanks

Paolo

BTW: does anyone know how to change the title of the thread since i clearly made a mistake ?