Forum Discussion
update cellnames in formula
I cannot get apply names to work. I get an error popup window that says: "Microsoft Excel cannot find any references to replace. The formula that contains that cell reference that I want to replace consists of the following: =B165*('Cover Page Major Assumptions'!$B$26)*-1
I am trying to replace the reference to B26 with the named range Total_Income_Tax_Rate. B26 is actually located on a separate sheet - and the scope of the name is "workbook". I cannot get "Apply Names" to work!! It is very frustrating.
Thank you. I appreciate your help.
Another person suggested using Find and Replace which I think will work fine and won't be hard to do.
It's funny - I use Find and Replace all the time and never for one second considered it for this problem. Sometimes the solutions are so simple - yet not obvious when you get fixated on doing it a certain way. My fixation on Apply Names prevented me from thinking it through clearly.