ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Linking infor from spreadsheet into word (https://www.excelbanter.com/links-linking-excel/87603-linking-infor-spreadsheet-into-word.html)

MMC

Linking infor from spreadsheet into word
 
I have info on a worksheet in Excel 2002 and have linked this to a word
document. I have formated the word document but when I make changes to the
worksheet and update the data from the linked file my format is overwritten.
Is there any way around this???

MMC



macropod

Linking infor from spreadsheet into word
 
Hi MMC

Word allows you to link the data using various formats, some of which reset
when updated, and some of which don't.

For example, if you inserted the link as an Excel worksheet, it will tend to
reset its aspect ration, in particular, to match that of the source data. If
you link the data in RTF format, you can largely control the destination
formatting by applying the style names to the data in Excel that you want
the data to adopt when it arrives in the Word document. You also have the
option to link the data as unformatted text, which allows you to reformat as
you like in Word. Each approach has its benefits and drawbacks.

Cheers


"MMC" wrote in message
...
I have info on a worksheet in Excel 2002 and have linked this to a word
document. I have formated the word document but when I make changes to

the
worksheet and update the data from the linked file my format is

overwritten.
Is there any way around this???

MMC






All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com