Only thing I can think of is that auto-calculation is turned off for that sheet. Try entering what I said, then hit the F9 key. If it then updates, it's because auto-calculation was switched off. If it doesn't, I'm not sure what the problem might be.
Only thing I can think of is that auto-calculation is turned off for that sheet. Try entering what I said, then hit the F9 key. If it then updates, it's because auto-calculation was switched off. If it doesn't, I'm not sure what the problem might be.