Excel Problem

[XCalibre]

Okay I've got this spreadsheet, it's been working fine for the last 3 months and now all of a sudden today, it's not formulating any of the data. All the formula's is still in the cells, they're just not updating the fields. Any ideas?

Thanks

 

[Vaporized]

Fix

Hi,

Check under "Tools" -> "Options" then the "Calculation" tab.
You'll find that the calculations are set to update manually, just change it to automatic and that should be it.

 

[XCalibre]

I love you man

 

[Ou grote]

or push F9
Look on the bottom left status bar, if u see the word "Calculate" there. It means it's on manual.

 

[XCalibre]

Yeah it changed to manual. Bloody hell, I was scratching my head big time