answersLogoWhite

0

Select the data in the spreadsheet and copy it. Go to the Word document and in the Edit menu pick Paste Special and Paste Link. A link will be established so that when the spreadsheet changes, the data in the word processing document will also change.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

If I Insert a chart from Excel Into a Word document and it and change what has happen?

If you do a regular copy and paste, then the chart in the Word document will not change if the data in the Excel spreadsheet does. If you want it to always represent the data as it is the Excel document when it is changed, then you need to link the chart in the Word document to the spreadsheet. You can do it using the Paste Link facility.


How do I link an Excel spreadsheet item to a paragraph in a Word document?

You can use a hyperlink to link from a Word document to an Excel document. Select the text you want to act as the link and press Ctrl-K. You can then find the excel workbook you want to link to. You can also copy from an Excel document and paste as a hyperlink, using Paste As Hyperlink in the Word document. This can link to a specific point in the Excel Workbook. You can also do a Paste Link to maintain a connection between the two files, so that when there are changes in the Excel workbook, they will be seen in the Word document.


Advantages software can Excel be integrated with Word?

Excel and Word can be integrated. You can have some of the spreadsheet appear as a table in Word. If you set a link between them, then when Excel updates, so will the Word document. Word does have the facilities to do its own calcuations in tables, but they are limited and so Excel is better. So if you want the figures in a Word document and to keep them up to date as they change in the Excel document, then a link is the way to do it. You would copy the data you want in Excel, and then do a Paste Link in the Word document.


Can you open Excel with Microsoft PowerPoint?

You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.You can put a link into a Powerpoint document that will open an Excel file in Excel.


Can an external Excel spreadsheet or a webpage be linked into a word document?

Yes. To insert a link, type the text you want as the link and select it. Then either press Ctrl and K, or go to the Insert menu and pick Hyperlink. In the dialog box that opens you will be able to choose the file or page which you want your link to go to.


Have you linked the files when you connect a Word document to a separate Excel worksheet?

If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.


What other applications can link with Excel?

Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.Any of the Microsoft applications, like Word, Access, Powerpoint etc. can be linked to Excel. Other spreadsheet and database applications in particular can link to it.


How do you quickly determine whether spreadsheet data displayed in a Word document is linked to source file?

To quickly determine if spreadsheet data in a Word document is linked to a source file, right-click on the data and choose "Linked Worksheet Object" or "Linked Excel Chart" if available. If the option to "Edit Links" appears, it indicates that the data is linked to an external file. Additionally, you may see the "Update Link" prompt when opening the document, which further confirms the data’s linked status.


Can you link a chart in PowerPoint to an Excel spreadsheet file?

yes, just add an hyperlink in your presentation to the excel spreadsheet on your PC, if you cannot find it, save a copy to the desktop, then link to it there. To insert a hyperlink in PP click on insert/hyperlink.


How do you link an external Excel spreadsheet into a webpage?

Ensure you have access to a Web server.Upload the Excel file to the server by whatever method you choose.Insert a hyperlink to the Excel file in your web page code. If the file is located in the FILE directory, the HTML code would be: sheet.Change the link information to whatever is appropriate for your site.Save the web page file to the server.Test your new link to ensure it works.Close your access to the server.


Solution of Black-Scholes equation?

The related link gives you an Excel spreadsheet with the solution of the Black-Scholes equation


How is the document panel displayed in Microsoft Excel?

To display the document panel in Microsoft Excel click the Menus tab, then click the file drop down menu, and there you will find the View Document Properties link.