MidwestTransplant
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:02 PM
Original message |
|
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
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:04 PM
Response to Original message |
|
try using find & replace. Might be faster.
|
Iris
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:05 PM
Response to Original message |
2. That's odd. What version are you using? |
Blue Diadem
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:07 PM
Response to Original message |
|
Calculation settings set to automatic?
|
MidwestTransplant
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:13 PM
Response to Reply #3 |
|
So strange it started happening a couple of weeks ago. Using 2002.
|
Blue Diadem
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:15 PM
Response to Reply #3 |
|
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
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Jan-06-05 08:15 PM
Response to Reply #3 |
|
That was the problem. Have no idea how it would have changed.
Thanks all!
|
DU
AdBot (1000+ posts) |
Fri Apr 26th 2024, 11:08 AM
Response to Original message |