Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking Excel file and Word File
I want to link data from an Excel file to a Word file so that data changed in
the Excel file will be automatically updated in the Word file. (Office 2003) |
#2
|
|||
|
|||
Have you tried InsertObject? Be sure to click the Create From File tab.
-- Stefan Blom Microsoft Word MVP "hanadiv" wrote in message ... I want to link data from an Excel file to a Word file so that data changed in the Excel file will be automatically updated in the Word file. (Office 2003) |
#3
|
|||
|
|||
Actually I think I found it. I copied the data from Excel and in Word:
EditPaste special. Checking Paste Link. Thanks "Stefan Blom" wrote: Have you tried InsertObject? Be sure to click the Create From File tab. -- Stefan Blom Microsoft Word MVP "hanadiv" wrote in message ... I want to link data from an Excel file to a Word file so that data changed in the Excel file will be automatically updated in the Word file. (Office 2003) |
#4
|
|||
|
|||
I'm glad to learn that you found a solution.
-- Stefan Blom Microsoft Word MVP "hanadiv" wrote in message ... Actually I think I found it. I copied the data from Excel and in Word: EditPaste special. Checking Paste Link. Thanks "Stefan Blom" wrote: Have you tried InsertObject? Be sure to click the Create From File tab. -- Stefan Blom Microsoft Word MVP "hanadiv" wrote in message ... I want to link data from an Excel file to a Word file so that data changed in the Excel file will be automatically updated in the Word file. (Office 2003) |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel file and Word File
I have a problem here can someone please solve it. I am tryng to paste link a
spreadsheet from Excel 2003 to Word 2003, but I am receiving the following ,messages: "Word cannot obtain the data for the Excel.Sheet.8 link" and then Excel shuts down to a recovered sheet and I am also getting the following "There is insufficient memory. Save the document now" Although this is something which can be easily done on any PC, the problem is only occuring on one particular PC which just had a fresh installation running XP SP2 and Office 2003 SP2. I have tried to uninstall Office and reinstall again but with no results. Yesterday I reformatted the PC again and made a fresh installation including Office 2003 with all possible updates from Microsoft and funnily enough I still have the problem. Please someone HELP ME as this is driving me crazy.ANY HELP PLEASE |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel file and Word File
Hi ?B?Z2F1Y2FudGg=?=,
I have a problem here can someone please solve it. I am tryng to paste link a spreadsheet from Excel 2003 to Word 2003, but I am receiving the following ,messages: "Word cannot obtain the data for the Excel.Sheet.8 link" and then Excel shuts down to a recovered sheet and I am also getting the following "There is insufficient memory. Save the document now" Although this is something which can be easily done on any PC, the problem is only occuring on one particular PC which just had a fresh installation running XP SP2 and Office 2003 SP2. I have tried to uninstall Office and reinstall again but with no results. Yesterday I reformatted the PC again and made a fresh installation including Office 2003 with all possible updates from Microsoft and funnily enough I still have the problem. Please someone HELP ME as this is driving me crazy. My first thought was a problem in the Registry, but reformatting the machine should have solved that. My next suspicion would be that you're installing some program that's interfering with the basic OLE server/client functionality. Such as an anti-virus or file management software? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel file and Word File
I linked an excel cell into Word using paste special, then paste link as
object. When both file stored in local hard drive, the Word update the data from excel everytime it opened, but when both files stored in a server, it couldn't update the link automatically. I have to right click each link then select Update Link to get the data updated. |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel file and Word File
Hi Mike,
What version of Word and Excel? If you use Alt+F9 to toggle the field code display, what does the field show in both the 'works' and 'doesn't work' case. =================== "Mike" wrote in message ... I linked an excel cell into Word using paste special, then paste link as object. When both file stored in local hard drive, the Word update the data from excel everytime it opened, but when both files stored in a server, it couldn't update the link automatically. I have to right click each link then select Update Link to get the data updated. -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel file and Word File
Hi Bob,
I'm using Word and Excel 2003. The worked link is { LINK Excel.Sheet.8 "C:\\Documents and Settings\\michael.chong\\My Documents\\Testing Automation\\test-status.xls" "Status!R3C4" \a \p \* MERGEFORMAT } The non working link is { LINK Excel.Sheet.8 "\\\\eurocoptermalaysia.com\\dfsroot\\public\\Plan ning\\Michael Doc\\Aircraft Status\\EC 120B 1472 XX-XXX.xls" "Status!R3C4" \a \p } Regards, Michael "Bob Buckland ?:-)" wrote: Hi Mike, What version of Word and Excel? If you use Alt+F9 to toggle the field code display, what does the field show in both the 'works' and 'doesn't work' case. =================== "Mike" wrote in message ... I linked an excel cell into Word using paste special, then paste link as object. When both file stored in local hard drive, the Word update the data from excel everytime it opened, but when both files stored in a server, it couldn't update the link automatically. I have to right click each link then select Update Link to get the data updated. -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is word perfect compatible with office word? | Microsoft Word Help | |||
Envelope Address | New Users | |||
How do I create & merge specific data base & master documents? | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge |