I have setting up documents with multiple worksheets. When I initially set
the file up I can type info in worksheet one and have the text display on a
2nd,3rd (etc.) with no problems. However, sometimes this stops working and
the 2nd,3rd worksheets will only display the formula for example =Sheet1!A1
instead of the text written. WHY?