Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
Is there a way to create a cross-reference to a math formula -- including a
reference that is located in a separate table from the one that contains the formula? If so, is there any way to make the cross-references auto-update (or do they have to be selected and F9'd every time the data returned by the math formulas changes)? Thanks. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
Bookmark the formula and use Insert | References | Cross-reference to the
bookmark. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "mkraft" wrote in message ... Is there a way to create a cross-reference to a math formula -- including a reference that is located in a separate table from the one that contains the formula? If so, is there any way to make the cross-references auto-update (or do they have to be selected and F9'd every time the data returned by the math formulas changes)? Thanks. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
Bookmark the formula and use Insert | References | Cross-reference to the
bookmark. Thanks -- will that *auto-update* the value in the cell where the bookmark is located when the 'original' value changes? I don't want to have to navigate to every bookmark to do it manually (F9 ad infinitum). |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
Alternatively, if you've got multiple cells to refer to in a single table, bookmark the whole table and use a formula like:
{=SUM(Table1 A1)} where 'Table1' is the bookmark name and 'A1' is the cell reference. As to the auto updating, unless the document is protected for forms or you're using a macro, the results will only update via selecting the cross-reference and pressing F9, doing a Print Preview or printing the document. -- Cheers macropod [MVP - Microsoft Word] "mkraft" wrote in message ... Is there a way to create a cross-reference to a math formula -- including a reference that is located in a separate table from the one that contains the formula? If so, is there any way to make the cross-references auto-update (or do they have to be selected and F9'd every time the data returned by the math formulas changes)? Thanks. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
"macropod" wrote:
Alternatively, if you've got multiple cells to refer to in a single table, bookmark the whole table and use a formula like: {=SUM(Table1 A1)} where 'Table1' is the bookmark name and 'A1' is the cell reference. Thanks. How does one bookmark an entire table? |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
Hi mkraft,
1. Select the table. 2. Use Insert|Bookmark. -- Cheers macropod [MVP - Microsoft Word] "mkraft" wrote in message ... "macropod" wrote: Alternatively, if you've got multiple cells to refer to in a single table, bookmark the whole table and use a formula like: {=SUM(Table1 A1)} where 'Table1' is the bookmark name and 'A1' is the cell reference. Thanks. How does one bookmark an entire table? |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
"macropod" wrote:
1. Select the table. 2. Use Insert|Bookmark. Thanks, but what I meant is: If the intention is for the second table to have cells that contain bookmarks which cross-reference values in cells of the first table, how does bookmarking the entire second table achieve that? |
#8
Posted to microsoft.public.word.tables
|
|||
|
|||
Creating cross-references to math formulas
Hi mkraft,
I didn't suggest bookmarking the second table. In fact, this is the first mention I've seen of a second table. The only table that needs to be bookmarked is the table being referred to in the cross-references. -- Cheers macropod [MVP - Microsoft Word] "mkraft" wrote in message ... "macropod" wrote: 1. Select the table. 2. Use Insert|Bookmark. Thanks, but what I meant is: If the intention is for the second table to have cells that contain bookmarks which cross-reference values in cells of the first table, how does bookmarking the entire second table achieve that? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How format numbers resulting from 'math' formulas in WORD tables? | Tables | |||
Cross-References | Microsoft Word Help | |||
Table formulas and references | New Users | |||
Help - creating forms and formulas in Word | Microsoft Word Help | |||
Help - creating forms and formulas in Word | Mailmerge |