Insert and automatically update Excel tables in Word

How to insert an Excel table in Word, and the table is updated with the contents of the Excel file, I have a simple test today, it is easy to complete. Now say the steps:

Before you start, inserting a sentence that seems useless and really important: my Office version is office2003.

First, set up an Excel table, and enter some content randomly. Then create a new Word document, where you need to insert the table, select menu: Insert (I) "-->" Object (O) ... "browse (B)" On the right side of the--> Object dialog box, select the second page "created by file (F)"--> "filename (N)", You can find your Excel file from the browse, if you are ok here, the contents of the direct Excel file are added to Word, but!! This will not be real-time with the new, note that the right also has a check box "link to the file (K)", if here √, we can achieve the desired effect, Excel file update, Word document content also changed together.

The advantage of this approach: Needless to say, it's not to mention that, and, after you open the Word document, double-click the Excel table area, you can open the Excel table directly to edit, edit the end of Excel, in Word Excel table mouse right click, select! Update link (D) can be updated immediately. And every time you open a Word document, a dialog box asks if you want to update the link.

The downside: Every time you open a document pop-up dialog box needs to decide whether to update, to the general user feel very troublesome, and if updated, every time you close the Word document will ask you whether to save. Another disadvantage is that if the contents of the Excel file is huge, it is finished, directly linked to all the Excel files, it will be too busy to die you. Below I will also say a simpler link method.

Another point to note the main points: the link to Excel documents do not delete, delete can not edit or update the contents of the content, although the last thing to save the. After a simple test, Excel changes file names, moves, and so on, and does not affect the automatic updating of Word documents.

If you are interested, try inserting word that can be updated automatically in an Excel table, which is basically the same way of doing things.

Lunch at noon, and carefully think about it before the passage of the "object (O) ..." menu link Excel table is the link to all, this is not actually I expected the effect, is it to cooperate with the update to create a small area of the Excel file? Then why bother? Although I have taken into account that even all the Excel files that have been linked to the link, you can find the action button by modifying the image, such as zooming in, cropping (in the right mouse button, selecting the "Show" Picture toolbar), but then I found a more advanced approach. Listen to me slowly ... (A tomato is flying in the distance, I am very skillful to escape ...) ）

Now you have to insert parts of the Excel table in the Word document, in fact it is very simple, open Excel, select the area you want to link to Word, select Copy (shortcut key CTRL + C, right mouse button click "Copy" ", through the Menu" edit (E) "-->" Copy (c) " Three methods are available), and then open Word (note!). Do not close excl here), click "Edit (E)" "-->" paste (S) ... "--> Paste dialog box appears on the left side of the Select pasted link (L), otherwise it will not be automatically updated, in the form of Microsoft Office Excel Worksheet object, point OK. Okay, now it's the same as it was before, insert a "picture" format Excel table, the difference is that right-click the table, select the linked sheet object (O) "-->" link (K) ... ", the dialog box that appears, if you click" Change Source (N) ... ", In the Change Source dialog box that appears, you can change the Excel path (nonsense) and, in addition, one more item (E) on the right side of the filename (N) ... "Click to change the specific location of the Excel table, such as Sheet1 to Sheet2, or specific selection positioning changes." However, the General original Excel table changes or directly copied paste a bit better, with this method of change is somewhat complicated.

However, the above two methods, linked to the table are "picture" format, this method and the Word document in fact the table is quite incompatible, very inconvenient to operate, after my efforts again, I found a better way. The above two methods are invalid, we need not learn. (another egg came in the distance, and I was out of the corner ...) ）

Well, as the second method begins, open Excel, select the table you want to link, copy good, do not close, and then paste in Word (shortcut Ctrl + V, right mouse button "paste (p)", through the Menu "edit (E)" "-->" Paste (p) "Three methods can be), Then notice that there is a "Paste Options" icon in the lower right corner of the table, which is the "Paste" icon, right, click on this, select "Keep the original format and link to Excel (E)" or "match the destination area table style and link to excel (L)", in fact, these two points after the results are basically the same, see? The form is no longer a picture form, it is the kind of form that is used in Word, is it more convenient to operate through the form of word again? And the formatting of the table doesn't change with the Excel file format, and the table in Word extracts only the values from the Excel file.