Need Help please

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
Sounds like you have manual calculation turned on. Either press F9 to
calculate entire sheet, or go to Tools-Options->Calculation, and select
automatic.
 
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.
 
Select the cells.

Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP
 
Back
Top