Jim,

Tolja. Every time you embed, or even copy an embedded object, you get
another copy. File gets huge. Disk manufacturers profits soar. Keep one
workbook embedded, and edit it as necessary -- any part of any sheet -- you
have access to the entire embedded workbook. Copy and paste-link stuff from
anywhere in that embedded workbook to anywhere in the Word document as
needed. It will update as the workbook is updated.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jim" <me@hree.now> wrote in message
news:cFzke.5242$X92.2121@newsread2.news.pas.earthlink.net...
> Well I tried that approach today but it embeds a new copy of the workbook
> at
> each embed point. Not only does the Word file get Huge but the workbooks
> are different so they don't produce the same correct answer that one
> workbook does.
>
> I guess I will have to try automating the link repoiinting procedure. I
> used the pair of files again today to prepare a report for a project and
> it
> was a pain to go through all the links. Fortunately it was a small
> project
> with few (16) pages.
>
> "Earl Kiosterud" <nothanks@nospam.com> wrote in message
> news:Ou9T2l5XFHA.252@TK2MSFTNGP12.phx.gbl...
>> Jim,
>>
>> You may still want to use an embedded workbook. When you embed any part
> of
>> any sheet, it actually embeds the entire workbook in the Word document.
>> From now on, the workbook lives in the Word document, and you can then
>> access any part of it by double-clicking it into edit mode (you're in
> Excel
>> now). You can copy stuff from any sheet, and paste-link it to other
>> parts
>> of the Word document. Note that if you copy the embedded object to
> another
>> part of the Word document, you'll create another independent copy, which
> you
>> don't want.
>> --
>> Earl Kiosterud
>> mvpearl omitthisword at verizon period net
>> -------------------------------------------
>>
>> "Jim" <me@hree.now> wrote in message
>> news:RJcke.4751$X92.3037@newsread2.news.pas.earthlink.net...
>> >I can't do that because the spreadsheet contains from about 12 to 75
> sheets
>> > depending on the project size. Most sheets read project information
>> > within
>> > the first few sheets and use that in their calculations. I need to
>> > make
>> > changes throughout the spreadsheet to fit the individual project.
>> >
>> > I then use the individual sheets as pages within the Word document.with
>> > report text (which varies from project to project) interspersed between
>> > the
>> > pages. This allows me to produce a finished report with Table of
>> > Contents,
>> > correct page numbering and referencing and the other polishes of Word.
>> >
>> > "Earl Kiosterud" <nothanks@nospam.com> wrote in message
>> > news:eFLOtTuXFHA.2080@TK2MSFTNGP15.phx.gbl...
>> >> Jim,
>> >>
>> >> One solution is to embed the Excel workbook in the Word document. Now
> to
>> >> update it, just double-click it, change data as necessary in the
>> > worksheet,
>> >> then click outside of it to be back in Word. You have only one file
>> >> to
>> > cart
>> >> around now, and no links to worry about. Updating the worksheet
> requires
>> >> the user has Excel installed, but viewing it inside the Word document
>> >> does
>> >> not.
>> >>
>> >> To embed it, select the range to be displayed (changeable later), and
>> > Copy.
>> >> Go to Word, Edit - Paste special - Excel object. Don't use Paste
>> >> Link.
>> >> Done. OLE!
>> >>
>> >> Pun intended.
>> >> --
>> >> Earl Kiosterud
>> >> mvpearl omitthisword at verizon period net
>> >> -------------------------------------------
>> >>
>> >> "Jim" <me@hree.now> wrote in message
>> >> news:pu0ke.1022$oT1.23@newsread1.news.pas.earthlink.net...
>> >> >I have an excel spreadsheet that contains calculations and a Word
>> > document
>> >> > that has a number of link references to it within the text of a
> report.
>> >> > Everything works fine and the excel sheets show up in the report as
>> >> > another
>> >> > page with headers and footers and correct page numbers etc.
>> >> >
>> >> > The problem occurs when I want to copy the two files to another
> project
>> >> > subdirectory and then try to make chnges to both. All the links in
> the
>> >> > Word
>> >> > document still refer back to the original excel spreadsheet back in
> the
>> >> > first project subdirectory. I have to manually repoint all the
>> >> > links
>> >> > to
>> >> > the
>> >> > new project subdirectory. Is there any way to cause the link to be
> to
>> >> > a
>> >> > relative address, that is make it look for the excel file in the
>> >> > same
>> >> > directory that contains the Word file? I can only figure out how to
>> > tell
>> >> > it
>> >> > absolute addresses of links
>> >> >
>> >> > I will also post this in the Word group..
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>