PDA

View Full Version : HELP: Damn you Excel!

Balldog
02-09-2005, 08:23 AM
Ok, so I have this spreadsheet at work which I use to track supplier performance. I have used the same spreadsheet for this being the 3rd year, just changing the dates. i.e. - 2003, 2004, 2005

Well its time for my monthly update and the formulas are no longer working, they are there but they are not updating as I enter the information. Anyone know how to solve this problem?
KevinNU7
02-09-2005, 08:25 AM
Try hitting F9
KevinNU7
02-09-2005, 08:26 AM
Go to the Top menu bar Click

Tools ---> Options ----> Calculation

Make sure the calculation has automatic selected
Balldog
02-09-2005, 08:29 AM
Go to the Top menu bar Click

Tools ---> Options ----> Calculation

Make sure the calculation has automatic selected

That worked! Thanks you are a life saver!!! :)
FrogMan
02-09-2005, 08:33 AM
damn, too late! I would have liked being a life saver for once in my life!!!


:D

FM
KevinNU7
02-09-2005, 08:58 AM
DON'T YOU DIE ON ME!