Embbed Excel file in Word- Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chance224 - 23 Jan 2008 02:13 GMT

I have a pricing sheet in Excel that is embbeed and linked to a word
document. Currently it fits perfectly on one page. If I add one more row to
the Excel file, how can I have it print that row on the next page?

Chance224

Reply to this Message

Stefan Blom - 23 Jan 2008 12:31 GMT

In Word, an embedded worksheet object cannot span multiple pages.

What you can do is copy the cells in the Excel sheet and, in Word, Paste
Special, as "Formatted Text (RTF)," choosing the "Paste link" option. If you
change the formatting and/or calculations in the Excel file, the linked data
in Word can be updated to reflect the changes.

Signature

Stefan Blom
Microsoft Word MVP

>I have a pricing sheet in Excel that is embbeed and linked to a word
> document. Currently it fits perfectly on one page. If I add one more row
> to
> the Excel file, how can I have it print that row on the next page?
>
> Chance224

Reply to this Message

Chance224 - 29 Jan 2008 20:00 GMT

Thanks

Is there a way to update the Range for the Excel link via Visual Basic? An
example would be if the linked range was Dayrate!R2C2:R35C3 and it needed to
be changed to Dayrate!R2C2:R40C3.

Thanks,
Chance224

> In Word, an embedded worksheet object cannot span multiple pages.
>
[quoted text clipped - 9 lines]
> >
> > Chance224

Reply to this Message

Stefan Blom - 30 Jan 2008 12:33 GMT

In Word, linked data is inserted as a LINK field. Press Alt+F9 to show/hide
field codes. Then change the range in the field code.

Signature

Stefan Blom
Microsoft Word MVP

> Thanks
>
[quoted text clipped - 22 lines]
>> >
>> > Chance224

Reply to this Message

Chance224 - 30 Jan 2008 19:13 GMT

Thanks

> In Word, linked data is inserted as a LINK field. Press Alt+F9 to show/hide
> field codes. Then change the range in the field code.
[quoted text clipped - 25 lines]
> >> >
> >> > Chance224

Reply to this Message

Stefan Blom - 31 Jan 2008 09:27 GMT

You are welcome.

After you've made the change, don't forget to update the field, by pressing
F9.

Signature

Stefan Blom
Microsoft Word MVP

> Thanks
>
[quoted text clipped - 33 lines]
>> >> >
>> >> > Chance224

Reply to this Message