How to automatically update excel table in word

[Savannah87]

Hi all,

How do I insert a excel table in word and form to excel with the contents of the file with the new and updated Today, I tested a bit, but it is difficult to complete. My office version is office2003. Please suggest. Thanks in advance.

[Raine]

First, create an excel table, which easily enter some of the elements. And then create a new word document, insert a table where needed, select the menu: Insert > "object (O) > Object dialog box appears, select the second page >by file creation (F )> - "file name ( N) has the right> View (B)., you can browse to find your excel file, if the point where you determine the contents of the file directly to excel on the increase to the word inside it but. This is not real-time with the new, pay attention to the right there is a check box , links to the file (K), if check mark id here, then you can achieve our desired results in, excel files after the update, word document where the contents along with changes. All the best.

[ZeDaX]

Using above approach has the advantage. Of course it goes without saying, along with updated, and, you open the word document, double-click the excel table area, you can directly open the excel table for editing, editing after the close excel, the excel table in word where the mouse right-click, Select > Update links (D) can be updated immediately. And each time you open word document, there will be the dialog box asking you whether you want to update the links. All the best.

[ThoMas321]

There are some disadvantages of doing so that pop-up dialog box each time you open a document will need to decide whether to update to the general users to feel a lot of trouble, and if the update, then close the word document for each will be asked if you want to save. Another disadvantage is that, if a huge excel document, then finished, and a direct link over all the excel files, then you had better to you. That link to excel documents do not delete, delete, or update can not be edited after the contents inside, although things are still the last save. Through simple tests, excel change file name, mobile and other operations will not affect the word of the document are updated automatically. Check and reply.

[Macarenas]

Word document insert a large table where the local, is actually very simple, open excel, select the word you want to link to the area, select Copy shortcut keys ctrl + c, the right mouse button point copy (C) , through the menu editor (E) - "Copy (C) , and then open the word, point the menu Edit (E)-" Paste Special (S) - "there's" Paste Special "dialog box on the left must choose Paste Link (L), otherwise it will not automatically update, and to select Microsoft Office Excel Worksheet object, point to determine. Well, now, and look the same as before, and inserted a "picture" format excel table, and before the difference is, the mouse right-click the form, select linked worksheet object (O)- "Link (K) , where the resulting dialog box, if you click change the source ( N ) , in the Change Source dialog box appears where you can change the excel path, In addition, in the file name over the right side of a item (E). Click excel table can be changed and the specific location, such as Sheet1 into Sheet2, or specific changes in Select location. But most of the original changes to the excel tables or direct copy and paste what is better, but some changes in this way complicated. Check and reply.

[JonathanD]

Open excel, select the required link to the form, copy good, do not close, and then paste in word (the shortcut key ctrl + v, the right mouse button point paste (P), by Menu Edit (E) - "Paste (P) three methods can be), then pay attention, form the lower right corner there will be a Paste Options icon is the" paste "icon, yes, point of this, Select retain the original format and links to Excel (E) or Match Destination Table Style and Link to Excel (L), in fact, exhausted the results of these two points, basically the same. Form is no longer the picture form, is not the kind of word-specific tabular form, so that word forms and through the operation, is not it more convenient. And the format of the forms will not end with a change in excel file format changes, word form inside the excel file just extract the values. All the best.