locomigo Posted March 30, 2007 Share Posted March 30, 2007 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 Link to comment Share on other sites More sharing options...
SilverBulletUK Posted March 30, 2007 Share Posted March 30, 2007 Tools > Option > CalculationIt should read 'Automatic'.Good Luck!!! Link to comment Share on other sites More sharing options...
locomigo Posted March 30, 2007 Author Share Posted March 30, 2007 Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now