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