Formula do not refresh automatically

Hi All,

I have a vlookup function in my spreadsheet. I dragged it to copy it into
all the cells in the column. But, the values do not refresh and I need to go
to them cell by cell and press F2 then Enter before the value is calculated.
What could be the problem, as the function is correct.

Thanks in advance.

Regards,
PS

Go to Tools->Options->Calculation.
Set the Calculation radio button to be automatic.

If you want to keep the default to manual, then just press F9 whenever you want the entire sheet to recalculate.

MS

Hi Guys,

I found the problem, I have set the calulation to manual. Sorry for bothering.

Regards,
PS

"PS" wrote:

> Hi All,
>
> I have a vlookup function in my spreadsheet. I dragged it to copy it into
> all the cells in the column. But, the values do not refresh and I need to go
> to them cell by cell and press F2 then Enter before the value is calculated.
> What could be the problem, as the function is correct.
>
> Thanks in advance.
>
> Regards,
> PS

Perhaps the calc mode was inadvertently switched to "Manual" instead of
"Automatic"?

Click Tools > Options > Calculation tab
Ensure that "Automatic" box is checked > OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"PS" <PS@discussions.microsoft.com> wrote in message
news:D4BBB1E9-2C71-41A6-9813-E27842A36A9C@microsoft.com...
> Hi All,
>
> I have a vlookup function in my spreadsheet. I dragged it to copy it into
> all the cells in the column. But, the values do not refresh and I need to
go
> to them cell by cell and press F2 then Enter before the value is
calculated.
> What could be the problem, as the function is correct.
>
> Thanks in advance.
>
> Regards,
> PS

Ignore my response, then <g>
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"PS" <PS@discussions.microsoft.com> wrote in message
news:DF3DCB1E-849B-4F4B-92F7-8CFC464CDA7B@microsoft.com...
> Hi Guys,
>
> I found the problem, I have set the calulation to manual. Sorry for
bothering.
>
> Regards,
> PS