We need to produce our accounts in Word but I would like to link the P&L,BS, Cashflow and Notes to Excel spreadsheats in order to ensure numerial accuracy within the accounts. The link would have to be such that any changes to the excel spreadsheets would be automatically updated in the word document. Is this feasible, and if so, how.
Regards
Alan
Alan Ross
Replies (3)
Please login or register to join the discussion.
Dead Easy
Highlight the section in Excel you want to include. Copy.
Go to your Word document, click the cursor where you want to insert the data, go to Edit, Paste Special. Here you have a number of options to insert the data in various forms, depending on whether you want to format it in Word or Excel. There is also a paste link option. With this checked, the Word document will update with changes in the Exel spreadsheet.
I could go on about how to control the formatting and sizing of the table in Word, but you're best off playing around with this yourself.