D
Deane
In a file with multiple sheets, the lead sheet has a text
cell that is referenced in succeeding sheets by means of a
cell reference. When the spreadsheet was opened, and the
cell was updated in the lead sheet, the succeeding sheets'
cells were populated with the actual text of the lead
sheet, replacing the formula reference. In addition,
other cells began to be populated with text from the lead
sheet that did not have previous references.
Can anyone help resolve this problem?
cell that is referenced in succeeding sheets by means of a
cell reference. When the spreadsheet was opened, and the
cell was updated in the lead sheet, the succeeding sheets'
cells were populated with the actual text of the lead
sheet, replacing the formula reference. In addition,
other cells began to be populated with text from the lead
sheet that did not have previous references.
Can anyone help resolve this problem?