How to link Excel to Word so that when changes are made in the Excel file, the word document is updated.
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.
Advanced Excel and Financial Modeling Training in July and August 2013 Over the next 2 months we will be running a number of Excel related courses. In particular we will be covering Advanced Excel and Financial Modeling training. The dates … Continue reading
Sheet Navigation in Excel 2013 Sheet navigation in Excel 2013 is slightly changed and on initial viewing you may wonder where some of the buttons have gone. In particular, you might want to know how you get to the very … Continue reading
Just a quick note to say your blog is brilliant. Full of useful bits of info. After your courses, I am by far the best modeller in our office, and we regularly get comments from our business partners on the quality of our models. Thanks for all the help,– Mike