Excell doesn't auto update cells anymore

  • Thread starter Thread starter Martin Schou
  • Start date Start date
M

Martin Schou

Hello NG
My Excel 2007 has stopped auto updating formula cells when one of the input
cells are changed. It will only update the value if i mark the cell and
press enter, or save the file.
How do I make it auto update again?
Martin
 
Hi Martin,

Formulas tab, Calculation Options, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello NG
| My Excel 2007 has stopped auto updating formula cells when one of the input
| cells are changed. It will only update the value if i mark the cell and
| press enter, or save the file.
| How do I make it auto update again?
| Martin
|
|
 
Back
Top