View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill
 
Posts: n/a
Default Cell references in tables should be relative, not absolute

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"EJfishsmell" wrote in message
...
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/comm...ic.word.tables