There is a formula referred to another sheet's cells.
After reordering the sheet, update the cells were referred by the formula, but the value of formula won't be updated.

Reproduce steps:

1. open a sheet has at least three sheets named Sheet1, Sheet2 and Sheet3 and order.
2. input text 123 into A1 in Sheet2
3. input formula =Sheet2!A1 into B1 in Sheet1
   • the value of B1 in Sheet1 should be 123
4. re-order Sheet2 back to Sheet3
   • such as Sheet1, Sheet3, Sheet2
5. modify cell A1 in Sheet2 to abc
   • the B1 in Sheet1 value doesn't update to abc but 0