Formulas not working on start up

[hcabs99]

I have an issue with a spreadsheet i created which works fine for all users apart from one!

None of the formulas work upon start up and have to be re-enabled each time, by pressing f2 on each formula , then pressing enter

Once i have done that, they all work ok.

There must be a setting applied or an issue with their build which is causing this issue, but i don't know what it is... They are using Excel 2007

Any ideas?

 

[Smitty]

Goto Office Button-->Options-->Formulas and make sure that Calculation is set to Automatic. You can also manually recalculate all formulas with F9.

HTH,

 

[Excelestial]

Go to your round windows emblem button, upper left corner, click on EXCEL OPTIONS at the bottom left...select FORMULAS...and tick the AUTOMATIC option under the CALCULATIONS OPTIONS header. Good luck.

 

[hcabs99]

Thanks both, very quick response....learnt something there,

As suspected it was set to manual, no idea why!!

Thanks again