Inserting Excel data as a linked OLE object Because the data is pasted into a table, you can use Word's table tools to format it and the file will be smaller because the data is not linked. With this method, the Excel data will be copied into Word as a table and the Word file will not update when the Excel file changes. Press Ctrl + V or right-click and choose Paste Values from the drop-down menu.Position the insertion point where you want the Excel data to appear.Press Ctrl + C or right-click and select Copy from the drop-down menu.Select the data you want to copy into the Word file.
Use this method if you do not need to update the Word file when the Excel data changes. You can easily copy data from Excel and paste it into a Word document.
Recommended article: How to Create a Table of Contents in Wordĭo you want to learn more about Microsoft Word? Check out our virtual classroom or live classroom Word courses > Inserting unlinked Excel data If you choose the second or third method, you will need to ensure that the Excel file remains in the same location with the same name or manage the link(s) using Edit Links. Create links to the Excel data in a Word table so that when the Excel file changes, the table will update.Import the Excel data into the Word document as a linked OLE (Object Linking and Embedding) object so that when the Excel file changes, the Word document will update as well.Copy the data in the Excel file, switch to the Word document and then paste the data where you want it to appear as a static copy.The following are three easy ways to import Excel data into Word by copying and pasting: If it's linked, you will be able to update, change and remove the links. When you import from an Excel file, you can choose to import linked or unlinked data. You can easily copy or import Excel worksheet data into Word documents. Sheets(nameOfTableOfContentsWorksheet).Cells(i + 5, 2).SelectĪ Linked or Unlinked Excel Worksheet Data into Word Filesīy Avantix Learning Team | Updated February 1, 2021Īpplies to: Microsoft ® Excel ® and Word ® 2010, 2013, 2016, 2019 or 365 (Windows) Sheets(nameOfTableOfContentsWorksheet).Cells(i + 5, 2) = tempWorksheetName TempLink = "'" & tempWorksheetName & "'!R1C1" 'Create the link from the current worksheet and link it to cell A1 Range("B3") = nameOfTableOfContentsWorksheet NameOfTableOfContentsWorksheet = "TableOfContents"ĪctiveSheet.Name = nameOfTableOfContentsWorksheet
The macro is supposed to do the same steps: Walk through all sheets, create a list entry for each sheet and insert a hyperlink to each sheet.ĭim tempWorksheetName, tempLink, nameOfTableOfContentsWorksheet As String As the first two methods works but is quite troublesome – especially for large workbooks – we’ll take a look at a third method: A VBA macro.
0 kommentar(er)
