If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|