Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking Excel data to tables in Word
Hi,
I have copied an Excel Table and used paste special (paste link) to insert it in a Word document. However, whenever i update something in the Excel spreadsheet, the info is not automaticallly updated in Word. I need to double click on the table in word to activate the worksheet, then the info will be updated on Word. Is there any way i can create automatic update links to my table in Excel? Or maybe my method of cut-and-paste is not the proper way of inserting data to word? Please kindly advise. Thanks, |
#2
|
|||
|
|||
Hi KSit,
Depending on how you're doing this, the Word document might not display the updated Excel results until the Excel Workbook is saved and, even then, until the Word document is closed and re-opened. What link format are you using? Cheers "KSit" wrote in message ... Hi, I have copied an Excel Table and used paste special (paste link) to insert it in a Word document. However, whenever i update something in the Excel spreadsheet, the info is not automaticallly updated in Word. I need to double click on the table in word to activate the worksheet, then the info will be updated on Word. Is there any way i can create automatic update links to my table in Excel? Or maybe my method of cut-and-paste is not the proper way of inserting data to word? Please kindly advise. Thanks, --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
#3
|
|||
|
|||
Hi macropod,
i used copy from excel then 'paste special' and click on 'paste link'. Is there another way to build an active link? Thanks, ksit "macropod" wrote: Hi KSit, Depending on how you're doing this, the Word document might not display the updated Excel results until the Excel Workbook is saved and, even then, until the Word document is closed and re-opened. What link format are you using? Cheers "KSit" wrote in message ... Hi, I have copied an Excel Table and used paste special (paste link) to insert it in a Word document. However, whenever i update something in the Excel spreadsheet, the info is not automaticallly updated in Word. I need to double click on the table in word to activate the worksheet, then the info will be updated on Word. Is there any way i can create automatic update links to my table in Excel? Or maybe my method of cut-and-paste is not the proper way of inserting data to word? Please kindly advise. Thanks, --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
#4
|
|||
|
|||
When you use 'paste special' and 'paste link', you'll see a number of other
formatting options (eg RTF, picture). These all perform somewhat differently than the default worksheet format, especially where formatting of the output is concerned. Some may/may not also give you more responsive updating. Cheers "ksit" wrote in message ... Hi macropod, i used copy from excel then 'paste special' and click on 'paste link'. Is there another way to build an active link? Thanks, ksit "macropod" wrote: Hi KSit, Depending on how you're doing this, the Word document might not display the updated Excel results until the Excel Workbook is saved and, even then, until the Word document is closed and re-opened. What link format are you using? Cheers "KSit" wrote in message ... Hi, I have copied an Excel Table and used paste special (paste link) to insert it in a Word document. However, whenever i update something in the Excel spreadsheet, the info is not automaticallly updated in Word. I need to double click on the table in word to activate the worksheet, then the info will be updated on Word. Is there any way i can create automatic update links to my table in Excel? Or maybe my method of cut-and-paste is not the proper way of inserting data to word? Please kindly advise. Thanks, --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |