是否需要将Excel 工作表(Excel worksheet)插入Word 文档(Word document)并将它们链接起来，以便在更新主Excel 工作表(Excel worksheet)时，它也会自动更新Word 文档(Word document)中的值？
嗯，实际上有几种方法可以将Excel 电子表格(Excel spreadsheet) 插入Word：链接、嵌入和创建新电子表格。无论您是嵌入还是链接，插入的Excel 电子表格(Excel spreadsheet)都不会自动更新，除非您专门在两个文件之间创建链接。
然而，一旦链接，嵌入或链接的电子表格中的数据将在原始Excel 电子表格(Excel spreadsheet)中检测到更改时更新。
除了插入现有的Excel 电子表格(Excel spreadsheet)之外，您还可以在 Word 中插入一个新的Excel对象(Word)，(Excel object)它基本上是在Word本身内部运行Excel 。
在本文中，我将向您展示如何使用所有三种方法进行操作，并说明创建链接所需的操作。
复制粘贴方法
让我们从第一种方法开始，它基本上只是从Excel复制粘贴到Word中。请注意，使用此方法时，您可以选择在Word 文档中仅包含(Word document)Excel 电子表格(Excel spreadsheet)的一部分。在第二种方法中，插入一个对象，整个电子表格将被放入Word 文件(Word file)中。
第 1 步(Step 1)：在Excel 电子表格(Excel spreadsheet)中选择要包含在Word中的区域，然后按Ctrl + C复制内容。
第 2 步(Step 2)：现在转到您的Word 文档，然后按(Word document and press) Ctrl + V将内容粘贴到Word 文件(Word file)中。为了链接，您必须单击右下角的粘贴选项(Paste Options)按钮，然后选择 匹配目标表样式并链接到 Excel(Match Destination Table Style and Link to Excel )或保留源格式并链接到 Excel。( Keep Source Formatting and Link to Excel.)
在较新版本的Word中，您会看到几个图标。您可以将鼠标悬停在它们上方，您会发现与上述相同的两个选项。
第 3 步(Step 3)：就是这样，现在您的表格将链接到原始Excel 文件(Excel file)。每当您更新Excel 文件(Excel file)并重新打开Word时，Word 都会询问您是否要使用链接文件中的新数据更新文档。
第 4 步(Step 4)：单击是(Yes)，您的表格将反映新值。如果您同时打开两个文件，您将实时看到更改。
显然有一些非常复杂的机制可以使所有这些工作，但幸运的是你不必担心它。它只是工作！请注意，如果您只是复制和粘贴而不选择其中一个链接选项，那么您只会插入一个独立的Excel 对象，在原始(Excel object)Excel 文件(Excel file)中进行更改时不会更新该对象。
此外，使用此方法，您无法在Word中编辑(Word)Excel数据并将其反映回Excel 电子表格(Excel spreadsheet)。它只能以一种方式工作。如果您在Word中更改数据并保存文件，当您再次打开文件时，您将收到与上述相同的消息，询问您是否要从链接文件更新文件。
如果单击“是”，它只会重新加载Excel 电子表格(Excel spreadsheet)中的最新值并覆盖您可能已更改的任何值。如果你想编辑原始的Excel 电子表格(Excel spreadsheet)，你可以在Word中通过右键单击数据，单击链接的工作表对象( Linked Worksheet Object)，然后单击编辑链接(Edit Link)来完成。
如果其他人创建了此Word 文档(Word document)而您不知道原始Excel 文件(Excel file)的位置，这将很有用。
插入对象方法
将Excel 电子表格(Excel spreadsheet)链接到Word的第二种方法是使用“插入(Insert)”菜单。
第 1 步(Step 1)：在 Word 中，单击“插入(Insert)” 选项卡，单击“对象(Object)”下拉菜单，然后选择“对象(Object)” 。
第 2 步(Step 2)：单击“从文件创建( Create from File)”选项卡，然后单击“浏览(Browse)”按钮选择您的文件。
第 3 步(Step 3)：选择文件后，您将在右侧看到两个复选框。如果你想链接Excel 电子表格(Excel spreadsheet)，你需要勾选链接到文件( Link to file)。如果要插入电子表格以使其不链接到原始文件，请不要选中该框。
如前所述，使用插入对象方法会将(Insert Object method)Excel 电子表格(Excel spreadsheet)的全部内容转储到Word中，而不仅仅是一部分。
请注意，如果您要双击Excel 对象(Excel object)（如果已链接），那么它只会在Excel本身中打开原始Excel 文件。(Excel file)
插入表方法
最后，您可以通过转到插入(Insert)选项卡，单击表格(Table)，然后单击底部的Excel 电子表格，将完全可编辑的(Excel Spreadsheet)Excel 电子表格(Excel spreadsheet)插入Word 。
仅当您想从头开始创建一个新的Excel 电子表格并且您计划从(Excel spreadsheet)Word本身对电子表格进行更改时，此方法才有用。不过，这种方法的优点在于它会插入一个浮动电子表格并(spreadsheet and load)在Word中加载整个Excel 菜单(Excel menu)，因此您可以像在Excel中一样插入公式等。
您可以像普通Excel一样添加工作表、创建过滤器、格式化单元格并执行所有操作。这是一种将一些数据插入到Word 文档中的快速简便的方法，您可以使用(Word document)Excel正确格式化，而不是依赖Word表格，这些表格很难看起来漂亮。
因此，这些都是您可以将Excel 电子表格(Excel spreadsheet)导入Word并将它们链接或不链接的所有不同方式，具体取决于您的需要。如果您有任何问题，请随时发表评论。享受！
Insert an Excel Worksheet into a Word Doc
Ever need to insеrt an Excel worksheet into a Word document and hаve thеm linkеd so that when you update the main Excel worksheet, it autоmatically updates the values in the Word documеnt also?
Well, there are actually a couple of ways to insert an Excel spreadsheet into Word: linking, embedding and creating a new one. Whether you embed or link, the inserted Excel spreadsheet will not automatically get updated unless you specifically create the link between the two files.
Once linked, however, then the data in the embedded or linked spreadsheet will update whenever changes are detected in the originating Excel spreadsheet.
In addition to inserting an existing Excel spreadsheet, you can also insert a new Excel object into Word, which basically runs Excel inside of Word itself.
In this article, I will show you how to do it using all three methods and explain what you need to do in order to create the link.
Copy Paste Method
Let’s start off with the first method, which is basically just copying and pasting from Excel into Word. Note that when using this method, you have the option to include only a part of the Excel spreadsheet in the Word document. In the second method, inserting an object, the entire spreadsheet will be placed into the Word file.
Step 1: Select the area in your Excel spreadsheet that you want to include in Word and then press Ctrl + C to copy the contents.
Step 2: Now go to your Word document and press Ctrl + V to paste the contents into the Word file. In order to link, you have to click on the Paste Options button at the bottom right and choose either Match Destination Table Style and Link to Excel or Keep Source Formatting and Link to Excel.
In newer versions of Word, you’ll see several icons. You can hover over them and you’ll find the same two options as mentioned above.
Step 3: That’s it, now your table will be linked to the original Excel file. Whenever you update the Excel file and reopen Word, Word will ask you if you want to update the doc with the new data from the linked files.
Step 4: Click Yes and your table will reflect the new values. If you have both files open at the same time, you’ll see the changes live.
There is obviously some pretty complicated mechanism that makes all of this work, but thankfully you don’t have to worry about it. It just works! Note that if you just copy and paste and don’t choose one of the linking options, you’ll just have a stand-alone Excel object inserted that won’t be updated when changes are made in the original Excel file.
Also, using this method, you can’t edit the Excel data in Word and have it reflect back to the Excel spreadsheet. It only works one way. If you make changes to the data in Word and save the file, you will get the same message above asking if you want to update the file from the linked files when you go to open the file again.
If you click Yes, it will simply reload the latest values from the Excel spreadsheet and overwrite whatever values you may have changed. If you want to edit the original Excel spreadsheet, you can do it from Word by right-clicking on the data, clicking on Linked Worksheet Object and then clicking on Edit Link.
This is useful if someone else created this Word document and you don’t know the location of the original Excel file.
Insert Object Method
The second way to link an Excel spreadsheet to Word is by using the Insert menu.
Step 1: In Word, click on the Insert tab, click on the Object dropdown and then choose Object.
Step 2: Click on the Create from File tab and click on the Browse button to choose your file.
Step 3: Once you choose the file, you will see two check boxes at the right side. If you want to link the Excel spreadsheet, you need to check Link to file. If you want to insert the spreadsheet so that it is not linked to the original file, then don’t check the box.
As mentioned previously, using the Insert Object method will dump the entire contents of the Excel spreadsheet into Word rather than just a portion.
Note that if you were to double-click on the Excel object (if linked), then it will simply open up the original Excel file in Excel itself.
Insert Table Method
Lastly, you can insert a fully editable Excel spreadsheet into Word by going to the Insert tab, clicking on Table and then clicking on Excel Spreadsheet at the bottom.
This method is only useful if you want to create a new Excel spreadsheet from scratch and you plan on making changes to the spreadsheet from within Word itself. What’s cool about this method, though, is that it’ll insert a floating spreadsheet and load the entire Excel menu too inside Word, so you can insert formulas, etc just as if you were in Excel itself.
You can add sheets, create filters, format cells and do everything just like the normal Excel. It’s a quick and easy way to insert some data into a Word document that you can format properly using Excel rather than relying on Word tables, which are really hard to make look nice.
So those are all the different ways you can get an Excel spreadsheet into Word and have them linked or not linked, depending on your needs. If you have any questions, feel free to comment. Enjoy!
