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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brian" wrote:

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

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.

"Luke M" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Brian" wrote:

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

Select the cells.

EditReplace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP

On Mon, 22 Dec 2008 08:15:01 -0800, Brian
wrote:

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.

"Luke M" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Brian" wrote:

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