Formula before naming cells

[Vindicit]

I have a data sheet with some formulas and I decided to clean it up a bit by naming my data cells. After I did that I can see that all my formulas still have the same "Sheet2!B6*2+B3+Sheet3!B1" type deal instead of saying the name of the cell like it should. Is there a way to refresh the workbook so that the formulas say the names of the cells without having to redo all the formulas? I couldnt find such a button and reloading the workbook didnt fix it.

Im using Excel 2010

 

[Smitty]

Welcome to the Board!

You can goto Formulas-->Define Name-->Apply Names.

HTH,

 

[Vindicit]

When I try that I get an error message saying "Excel cannot find any references to replace"

It seems that only works if the data is within the same sheet as the formula.

 

[Smitty]

In that case you should be able to add them through the "Use in formula" option. Just hightlight each section of the formula and replace it with a name from the list.