Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Embbed Excel file in Word- Formatting
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 |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Embbed Excel file in Word- Formatting
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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Embbed Excel file in Word- Formatting
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 "Stefan Blom" wrote: 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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Embbed Excel file in Word- Formatting
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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 "Stefan Blom" wrote: 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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Embbed Excel file in Word- Formatting
Thanks
"Stefan Blom" wrote: 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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 "Stefan Blom" wrote: 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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Embbed Excel file in Word- Formatting
You are welcome.
After you've made the change, don't forget to update the field, by pressing F9. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... Thanks "Stefan Blom" wrote: 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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 "Stefan Blom" wrote: 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. -- Stefan Blom Microsoft Word MVP "Chance224" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge from Excel file changes date formatting | Mailmerge | |||
How can I save an embedded Excel file in word back into an Excel | Microsoft Word Help | |||
Excel & Word Docs saved with file type as 'file' and window icon | Microsoft Word Help | |||
How do I download an excel file into WORD. I do not have excel | Microsoft Word Help | |||
How do I retain formatting from an Excel Data File to a Word Merg. | Microsoft Word Help |