I have a user who says that, on occasion, when she puts in numbers for a simple calculation, like SUM, when she goes to sum them the formula doesn't work. There's nothing wrong with the formula. I've checked and re-checked. The formula is fine. I've checked in Tools>>Options and the file is set to calculate automatically.
When I opened the file up on my PC it acted the same way, but when I re-entered the values into the appropriate fields the calculation kicked in and worked properly. Any idea what's causing this and how to fix it?
When I opened the file up on my PC it acted the same way, but when I re-entered the values into the appropriate fields the calculation kicked in and worked properly. Any idea what's causing this and how to fix it?