Cross-Referencing Between Documents

  • Thread starter Thread starter Ryan Ragno
  • Start date Start date
R

Ryan Ragno

Hi,

I have two huge .doc files (about 130 pages each):
1) is a document that has a lot of text/engineering guidelines
2) is comprised of about 4 VERY large tables, where in the leftmost column
of the table of every row are manual references to heading numbers in the
first document

At the moment, most of these references (in document 2) are done manually,
however any change in the first document (when inserting different sections)
puts all the manual references to specific sections of document 1 that have
already been done (in document 2) out and creates a HUGE nightmare to
manually do again.

I have looked up on MANY sites, and tried to sleuth through many questions
on the microsoft website to similar issues. I was hopeing to just use
cross-references in document 2 to refer to the sections in document 1, so
that when those heading numbers change i could have just updated the field,
however i don't think that is possible; leaving me having to probably use
bookmarks and hyperlinks: which would be fine if there was a way to update
the hyperlink name when the heading numbers in document 1 change as you can
with normal cross-references to headings by pressing CTRL+A then right
clicking and selection "update field".

Can anyone help me? I promise to answer many newbie excel questions to keep
the question/answer karma on my side! :P
 
Hi Cindy!

Thankyou for your extreemly prompt and helpful reply. I have worked out the
solution which includes the INCLUDETEXT field code without hyperlinks. There
are still some underlying problems with the solution though. If the document
1 name or directory changes, all references will show errors, but more
importantly, the bookmarks' names themselves are static/unchanging is there a
way to have thier names change with the references themselves or will i have
to simply settle with "bookmark1", "bookmark2", ... etc.

Thank you again :)
 
Back
Top