Convert cell formula reference from names to cell A1 references

[Hcleslie]

I have a complex formula, so I created cell labels to reference in my formulas. I think that this might confuse my co-workers and I would like to be able to convert back to A1 references. Seems like I have done this in the past and it was easy, but I can't seem to find this solution. Age or something... Any help would be appreciated.

Charlie

 

[yogia]

Hi Charlie:

How about ...

Tools|Options|Calculation > Workbook_options > uncheck Accept_Labels_in_Formulas



Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[Hcleslie]

Yogi, thank you for your reply. I tried this method and it did not work, so I Googled for more answers.

Found more information.

http://msdn2.microsoft.com/en-us/library/bb209650.aspx

You cannot "unapply" names; to delete names, use the Delete method.

John Walkenbach's "Power Utility Pak v6" Add-in tools for Microsoft Excel does have a "Unapply Names". I downloaded free trial and it worked fine.

http://www.j-walk.com/ss/pup/pup6/pup6trial.exe

After converting names to cell references, I then tested to see if unchecking box would allow me to use cell names in formulas. It did not allow.

Thanks again.

Charlie