REF fields

[Steve]

I'm using Word 2002. I don't know how to insert a REF
field, other than how it's described in the Help Index,
and that doesn't seem to work:

ex: {=protectedTable a1}

Also, how would I figure out the name of the cell to
reference if my table is irregular, i.e., columns and
rows don't match up across the table -- there may be
three cells in this row, and 4 in the next row, or some
cells may take two rows in one column?

 

[Suzanne S. Barnhill]

The most user-friendly way is to use Insert | Reference | Cross-reference.
If you have bookmarked data in a cell, then you will find that bookmark in
the bookmark list in the dialog.

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

 

[macropod]

Hello Steve,

When referencing cell values in a table from outside that
table, you have to set up a Bookmark for the table (Tab1,
say) then use one fo the functions listed below (even for
a single cell) to retrieve the table values from outside
the table (e.g. {=SUM(Table1 C1)} or {=SUM(Table1 A3)+SUM
(Table1 B3)}). Note: you can't type the braces (ie {}),
enter them as pairs via Ctrl-F9 and type the other data
between them.

Only the following functions can accept references to
table cells as arguments:
AVERAGE(), COUNT(), MAX(), MIN(), PRODUCT(), and SUM().

This technique can be useful when you need to refer to one
or more table values in the document's text, do math with
them or even refer to them in another table. Note that
this technique does not work with text strings, including
dates and other number/character strings, in tables - to
refer to them from outside the table, they must be
individually bookmarked and you can then refer to those
bookmarks directly.

As for which cell reference applies to a table with merged
cells, trial and error might be needed. Alternatively, I
think you can find which columns go with which column
references by seeing which single columns can be selected
as a group.

Hope this helps

Cheers

PS: Remove NO.SPAM from the above before replying.