#1   Report Post  
Posted to microsoft.public.word.docmanagement
Dawn Crosier, Word MVP Dawn Crosier, Word MVP is offline
external usenet poster
 
Posts: 425
Default Cross-references

Hi Aleksander -

You can cross-reference to any existing element (bookmarks, numbered
lists, headings, footnote, endnote, equation, figure or table) as many
times as you need to do so. However, multiple bookmarks need to have
unique names in the document.

Does that help?

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




"Aleksander" wrote in message
:

Hello,

If to make bookmark on the cell of the table and then to use Insert | Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander



No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.2/1270 - Release Date:
2/10/2008 12:21 PM


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Aleksander Aleksander is offline
external usenet poster
 
Posts: 4
Default Cross-references

Hello,

If to make bookmark on the cell of the table and then to use Insert | Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Stefan Blom Stefan Blom is offline
external usenet poster
 
Posts: 8,428
Default Cross-references

I can think of two methods which would omit the cell formatting (such as
borders) and just reference the contents of the bookmarked cell.

One method is to copy the cell and then use the Paste Special dialog box to
paste "Unformatted Text" as a link (click the "Paste link" radio button).
This inserts a LINK field that references the contents of the cell.

Alternatively, if the cell contents are numeric, you can create an ordinary
cross-reference and then add a formatting switch to the field code; this
suppresses the cell formatting. For example: After you've inserted the
cross-reference, press Alt+F9 to show the field code. You will see something
like this: { REF bookmarkname }. Add \# "#" to the end of the field code and
press F9 to update. Press Alt+F9 again to hide the field code.

--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote in message
...
Hello,

If to make bookmark on the cell of the table and then to use Insert |
Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create
cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander





  #4   Report Post  
Posted to microsoft.public.word.docmanagement
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Cross-references

Hi Aleksander,

Are you trying to cross-reference another cell from the same table? If the answer is yes AND the cells that you want to
cross-reference contain only numbers, then bookmarking the whole table will allow you to use the one bookmark for each
cross-reference. For example, suppose you want to cross-reference the values in cells A1 and B4. If you bookmark the table 'Tbl1',
then formula fields coded as:
{=SUM(Tbl1 A1)} and {=SUM(Tbl1 B4)} will retrieve the required values.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Aleksander" wrote in message ...
Hello,

If to make bookmark on the cell of the table and then to use Insert | Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Stefan Blom Stefan Blom is offline
external usenet poster
 
Posts: 8,428
Default Cross-references

"Stefan Blom" wrote in message ...
I can think of two methods which would omit the cell formatting (such as
borders) and just reference the contents of the bookmarked cell.

One method is to copy the cell and then use the Paste Special dialog box
to
paste "Unformatted Text" as a link (click the "Paste link" radio button).
This inserts a LINK field that references the contents of the cell.

Alternatively, if the cell contents are numeric, you can create an
ordinary
cross-reference and then add a formatting switch to the field code; this
suppresses the cell formatting. For example: After you've inserted the
cross-reference, press Alt+F9 to show the field code. You will see
something
like this: { REF bookmarkname }. Add \# "#" to the end of the field code
and
press F9 to update. Press Alt+F9 again to hide the field code.


Clarification: If your numbers include decimals, you will have to use
something like this instead (for two decimals): \# "#.##" (be sure to use
the decimal sign specified on your system).

--
Stefan Blom
Microsoft Word MVP




--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote in message
...
Hello,

If to make bookmark on the cell of the table and then to use Insert |
Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create
cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander











  #6   Report Post  
Posted to microsoft.public.word.docmanagement
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Cross-references

Hi Stefan,

Coding the switch as:
\# 0
or
\# 0.00
or
\# ,0.00
will give more consistent results. Using a # can result in leading and trailing 0s being displayed as spaces (eg instead of getting
'0' or '0.10' you might get ' ' or ' .1 ').

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Stefan Blom" wrote in message ...
"Stefan Blom" wrote in message ...
I can think of two methods which would omit the cell formatting (such as
borders) and just reference the contents of the bookmarked cell.

One method is to copy the cell and then use the Paste Special dialog box
to
paste "Unformatted Text" as a link (click the "Paste link" radio button).
This inserts a LINK field that references the contents of the cell.

Alternatively, if the cell contents are numeric, you can create an
ordinary
cross-reference and then add a formatting switch to the field code; this
suppresses the cell formatting. For example: After you've inserted the
cross-reference, press Alt+F9 to show the field code. You will see
something
like this: { REF bookmarkname }. Add \# "#" to the end of the field code
and
press F9 to update. Press Alt+F9 again to hide the field code.


Clarification: If your numbers include decimals, you will have to use
something like this instead (for two decimals): \# "#.##" (be sure to use
the decimal sign specified on your system).

--
Stefan Blom
Microsoft Word MVP




--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote in message
...
Hello,

If to make bookmark on the cell of the table and then to use Insert |
Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create
cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander










  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Stefan Blom Stefan Blom is offline
external usenet poster
 
Posts: 8,428
Default Cross-references

Good point. Thank you.

--
Stefan Blom
Microsoft Word MVP


"macropod" wrote in message ...
Hi Stefan,

Coding the switch as:
\# 0
or
\# 0.00
or
\# ,0.00
will give more consistent results. Using a # can result in leading and
trailing 0s being displayed as spaces (eg instead of getting '0' or '0.10'
you might get ' ' or ' .1 ').

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Stefan Blom" wrote in message
...
"Stefan Blom" wrote in message
...
I can think of two methods which would omit the cell formatting (such as
borders) and just reference the contents of the bookmarked cell.

One method is to copy the cell and then use the Paste Special dialog box
to
paste "Unformatted Text" as a link (click the "Paste link" radio
button).
This inserts a LINK field that references the contents of the cell.

Alternatively, if the cell contents are numeric, you can create an
ordinary
cross-reference and then add a formatting switch to the field code; this
suppresses the cell formatting. For example: After you've inserted the
cross-reference, press Alt+F9 to show the field code. You will see
something
like this: { REF bookmarkname }. Add \# "#" to the end of the field code
and
press F9 to update. Press Alt+F9 again to hide the field code.


Clarification: If your numbers include decimals, you will have to use
something like this instead (for two decimals): \# "#.##" (be sure to use
the decimal sign specified on your system).

--
Stefan Blom
Microsoft Word MVP




--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote in message
...
Hello,

If to make bookmark on the cell of the table and then to use Insert |
Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create
cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander













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
Cross References bse3 Microsoft Word Help 1 December 12th 07 12:39 AM
Help With Cross References smita Microsoft Word Help 19 December 14th 06 08:32 PM
Cross References Mike Faulkner Microsoft Word Help 3 November 1st 06 03:20 PM
cross references Pat Microsoft Word Help 1 July 11th 06 05:07 PM
It's all about cross-references... Thommy Microsoft Word Help 3 August 19th 05 03:51 PM


All times are GMT +1. The time now is 02:04 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"