Attachment 258197I have a problem that may be hard to describe. I'll do my best to explain what is going on.
1) I have a document created that is running in compatibility mode Excel 97-2003.
2) This document is on a shared folder and is shared with multiple computers.
3) The formulas show all zeros when the document is opened in Excel 2013
4) The formulas work correctly *Formulas calculate a result* when the document is opened in Excel 2007 and Excel 2010.
5) Periodically the formulas work correctly in Excel 2013.
Here is a picture of what is occurring:
Bookmarks