Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
EJfishsmell
 
Posts: n/a
Default 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   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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tables in Word should display cell references. EJfishsmell Tables 2 April 12th 06 11:20 PM
Absolute and Relative Hyperlinks in Office 2003 Mia Microsoft Word Help 4 May 22nd 05 10:52 AM
How to creat relative and shorthand file path names? 2dogs Microsoft Word Help 1 May 15th 05 12:11 PM
Master documents need relative references to subdocument file loc. Peter J Microsoft Word Help 6 March 13th 05 04:06 PM
Cell references in tables? The Shaker Microsoft Word Help 1 February 28th 05 03:02 PM


All times are GMT +1. The time now is 08:28 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"