HELP! I cannot figure out what is wrong. Using Excel 2000, I have two
workbooks, one of which is a summary workbook linked to multiple rows in a
detailed workbook. For example, in the Summary Workbook there is a formula
which links to (for example) cells in row 50 in the detailed workbook.
everything is fine until I insert a new row above row 50 in the detailed
workbook. That, of course, changes the old row 50 to row 51. But when I
open the Summary Workbook, that reference has not changed or been updated.
It is still referring to row 50. The cell references are relative, not
absolute. What is wrong? I need the cell references in the Summary workbook
to update if there have been new rows added to the detailed workbook. Can
anyone help me PLEASE?
--
LPS