Excel Help

[MidwestTransplant]

For some reason when I change numbers in a formula, the results aren't changing unless I go in and delete and replace the equal sign. Anybody know why this is happening or how to fix?

Thanks

[democracyindanger]

1. No idea but

try using find & replace. Might be faster.

[Iris]

2. That's odd. What version are you using?

[Blue Diadem]

3. Are your

Calculation settings set to automatic?

[MidwestTransplant]

4. How do I find out?

So strange it started happening a couple of weeks ago. Using 2002.

[Blue Diadem]

5. Tools-Options

then there should be a tab that says calculations. Sometimes they get flipped back to manual..had that happen to me a few times at work. Just a thought.

[MidwestTransplant]

6. Got it thanks

That was the problem. Have no idea how it would have changed.

Thanks all!