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

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 <atyahoo<dotcom
----
"PS" wrote in message
...
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 <atyahoo<dotcom
----
"PS" wrote in message
...
Hi Guys,

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

Regards,
PS