I have an issue where values in a spreadsheet revert to previous values AFTER the file has been reopened, and has been worked in for some time.    For example: Supplies costs are calculated in one File 1, and is referred to in File 2.  If we update File 1, the value in File 2 updates and we save.  Upon re-opening File 2, the value reflects the new, correct value, but if you perform certain actions (copy a tab, re-save the file), the value reverts to the previous amount.  It’s odd because I would more understand if it showed the old value upon opening, and then updated as it recalculated, but this is the opposite.  It shows the correct value upon opening, and then reverts to an old value that doesn’t even exist in the linked file. 

Any thoughts on what causes this, and how to fix? 

​I have an issue where values in a spreadsheet revert to previous values AFTER the file has been reopened, and has been worked in for some time.    For example: Supplies costs are calculated in one File 1, and is referred to in File 2.  If we update File 1, the value in File 2 updates and we save.  Upon re-opening File 2, the value reflects the new, correct value, but if you perform certain actions (copy a tab, re-save the file), the value reverts to the previous amount.  It’s odd because I would more understand if it showed the old value upon opening, and then updated as it recalculated, but this is the opposite.  It shows the correct value upon opening, and then reverts to an old value that doesn’t even exist in the linked file.  Any thoughts on what causes this, and how to fix?   Read More

​