Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Can I set up the formula to update automatically? | Excel Worksheet Functions | |||
Formula referencing deleted row (move up automatically) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) |