How to link Excel to Word so that when changes are made in the Excel file, the word document is updated.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Link Excel to Word document
This video clip shows you how to link Excel to word document in such a way that when you change the Excel file, it easily updates the Word document with the new numbers and text without losing the formatting. The areas we cover are the copy and paste special features as well as the update links in Word with some warnings on the issues you may encounter. We are also able to provide a robust solution for where you have hundreds of links and need to have the file update quicker than what Excel and Word currently do with the Link feature or the Mail Merge feature.