I work for a company that has two locations. One location is currently using
Excel 2002 while the other location is still using Excel 97. There isn't
much that we do that is overly advanced so we've never run into problems in
the past, but I ran across one this week that I cannot explain. I created an
expense report that does simple addition and subtraction. When I use this
(and I use Excel 2002), everything runs perfectly fine. However, when the
users that are on Excel 97 use it, the simple formulas do not update on their
own. However, they have found that if they minimize Excel and then bring it
back, it updates. If they do a print preview, it updates. When they save,
it updates. My first thought was that their calculation was set to manual
however it is actually set to automatic. Any thoughts on what might be
causing this or how to fix it? Any input would be greatly appreciated.