I have a workbook with several worksheets. One worksheet is used for data
entry. The other worksheets have links to this data entry worksheet. (Ex.
cell A1 in Sheet 1 has "=Sheet2!A1". ) When I enter data into one sheet it
doesn't automatically update the other worksheets. This doesn't seem right.
Can I fix the workbook so that it updates other worksheets automatically?