[Fairygodmother]

P.S. -- I use "insert Object" b/c it's important that I be able to produce
these 10 reports monthly by just updating the link (and making a few
pertinent changes in the WORD doc, of course). It's my understanding that I
cannot do that with "Insert File." Thanks.
--
The Fairygodmother


"CyberTaz" wrote:

Are you certain you're using the Insert *File* method and not Insert
*Object*? The former inserts the data as a Word Table which continues on for
as many pages as necessary, whereas the latter inserts the workbook as an
OLE object which cannot - and never could - span a page break.

HTH |:)
Bob Jones
[MVP] Office:Mac



On 12/12/07 4:56 PM, in article
, "Fairygodmother"
wrote:

Dear Stefan and Cindy,

The Insert/File works great for WORD-to-WORD connections (use it often), but
it doesn't solve the problem for links between WORD and Excel.

With 2003, I have the same problem described by t and Barb - when in a WORD
doc and link to an Excel worksheet, it will only show the worksheet to the
end of that page. The substance of the worksheet will not wrap over to the
next page(s). This is a new problem with v. 2003; I've been using this
feature successfully since the 90's. It's an important feature for reports,
and now, I find myself spending A LOT OF TIME having to work around this,
when before 2003, it was a snap!

Surely there is a setting deep in the caverns of WORD that will fix this,
but I can't find it. I've done everything I can think of on the Excel end
(re-formatting, yada-yada-yada, to no avail).

Please HELP! Thanks.