Need Help please

[Brian]

I am using a formula that returns info from another cell on a different
worksheet and it worked for the range of cells to which the formula was
applied, then I applied that same formula to several other ranges of cells
but changed the referenced worksheet. Problem is that a ref error appears in
all those other ranges until I double click the problem cell thereby
displaying the formula in the formula bar and when I simply hit enter, the
proper result is returned in that cell. So now for every error I must do
this double click and enter thing to get the formula to work. How then can
I do this in one step so that all of the cells with the error become
refreshed (for lack of a better term).
I did try to search for this problem but could not locate something similar.

Thank You,
Brian

 

[Luke M]

Sounds like you have manual calculation turned on. Either press F9 to
calculate entire sheet, or go to Tools-Options->Calculation, and select
automatic.

 

[Brian]

I have had the auto calculation on and it remains activated, however this
problem still exists. It is strange, all I have to do is double click the
cell and hit enter to get it to work nothing actually changes in the formula
itself. But I have a whole lot of cells to do this to and wish not to use
this method for all of them to work.
Brian.

 

[Gord Dibben]

Select the cells.

Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP