Non-calculating formulas

[locomigo]

Hello there,

I have an issue with my Excel program. I received a file last week and while it didnt show a virus, it has negated the ability for formulas to calculate properly. As you enter the data of what you are calculating, it does not auto update.

The only way I can get them to function is deleting the cell within which the formula resides. Then if I go and retype the formula again, it will calculate, but only if I delete what was previously there. Not only is this tedious, it is fairly aggravating. I am of the thought that it corrupted something within the profile settings, either within the program itself or my directory.

Any assistance or suggestions would be appreciated.

Thanks,

Keith

[SilverBulletUK]

Tools > Option > Calculation

It should read 'Automatic'.

Good Luck!!!

[locomigo]

Thanks!