Cell references in tables should be relative, not absolute

[EJfishsmell]

If you split a cell or insert a row or column, all formulas in the table that
reference individual cells or limited ranges of cells need to be corrected if
they refer to a cell to the right or below the split cell or inserted row or
column. If the cells had relative references, rather than absolute
references, in formulas this problem would be eliminated.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-59d00f846a23&dg=microsoft.public.word.tables

 

[Suzanne S. Barnhill]

If you need relative references, you need to be using Excel. If you have to
be using Word, you need to embed an Excel sheet. I venture to say Word will
*never* have this functionality.

If you split a cell or insert a row or column, all formulas in the table that
reference individual cells or limited ranges of cells need to be corrected if
they refer to a cell to the right or below the split cell or inserted row or
column. If the cells had relative references, rather than absolute
references, in formulas this problem would be eliminated.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-59d00f846a23&dg=microsoft.public.word.tables