I'm checking on an issue some of my employees are experiencing. They are each using Windows 7 and either Office 2003 or Office 2010, depending on the machine (we've experienced this between three different computers). We have an excel spreadsheet that we use for basic cost calculation that includes formulas, typically very basic ones like =A1*A2, where A1 is a quantity and A2 is a cost, both of which are hand entered.
Our problem is happening when the file is emailed then opened. Formulas are disappearing either in full or in part (replacing all calculated values with a formula in the cell to just values). In a few cases, several cells that had been recently modified changed from formulas (like that listed above) into the calculated value. Today, we had an entire spreadsheet turn from formulas into calculated values.
This is a totally new issue- we've been sending and receiving versions of this spreadsheet for over a decade without these issues.
Some of the files affected were sent as .xls and opened in compatibility mode (the ones only replaced in part), and the one replaced in full was sent in .xlsx.
I've tried some different options (editing from the temporary file location when opened versus saving to my desktop and opening, sending it to a Windows 10 computer to try it there, resending the file, etc.). Some files were sent 100% through Outlook, some were sent from AOL to Outlook (no poking fun at AOL here, the person has been using that account for about 20 years ;) ). I don't have access to any of the original files currently, but I've forwarded it from both the computer receiving it (using outlook) and from a linked iphone to a different computer and a different computer using gmail and google docs top open it. Outlook email is processed though an Alt-N MDaemon server.
In all cases, the sent email originated from outside our office and was opened on a computer at our office. I don't seem to have any problems sending files within the office.
I'm totally at a loss since there seems to be an exception to every common thread. Anyone have any ideas?