Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Cell references in tables should be relative, not absolute
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 |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tables in Word should display cell references. | Tables | |||
Absolute and Relative Hyperlinks in Office 2003 | Microsoft Word Help | |||
How to creat relative and shorthand file path names? | Microsoft Word Help | |||
Master documents need relative references to subdocument file loc. | Microsoft Word Help | |||
Cell references in tables? | Microsoft Word Help |