Accuracy of Accounts

Accuracy of Accounts

Didn't find your answer?

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.

aw_logo_2019
By Accounting WEB
23rd Mar 2001 01:01

moving & re-sizing the attachment
Hi,

I have tried the mtd suggested by Neil, but having problem moving or re-sizing.

Any help?

Thanks (0)
avatar
By neileg
08th Mar 2001 15:56

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.

Thanks (0)
aw_logo_2019
By Accounting WEB
08th Mar 2001 17:09

You're Right
Neil, you were right, its dead easy - when you know how. Thank you very much for your help, I foresee many hours of playing to get these links just right but at least I am now on the right track.

Best regards

Alan

Thanks (0)