How to change Name and update dependent cells?

[Don Culp]

I have a cell with a constant named X. How can I want to change
this name to N and automatically have all other cells that had previously
referred to X now refer to N?

Excel 97

Thanks,
Don Culp

 

[Niek Otten]

Hi Don,

Download Jan Karel Pieterse's Name Manager:

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a cell with a constant named X. How can I want to change
| this name to N and automatically have all other cells that had previously
| referred to X now refer to N?
|
| Excel 97
|
| Thanks,
| Don Culp
|
|
|
|