Formula do not refresh automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Perhaps the calc mode was inadvertently switched to "Manual" instead of
"Automatic"?

Click Tools > Options > Calculation tab
Ensure that "Automatic" box is checked > OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing formulas automatically 3
F9 Calc refresh does not work... 3
Formulas not calculating - Calculation is on Automatic & I pressed 2
Cell update - Automatically 1
Refresh Cells 1
excel cells changing to "#VALUE!" whenever another file is opened 8
formulas do not work 2
SUBTOTAL not refreshing when using advanced filter 2

Back
Top