Linking workbooks

Hi Genta

Thanks for getting in touch. Linking workbooks is a matter of creating a formula that references another workbook.

So for example:

=sum([MyFile.xlsx]Sheet1!A5:A10)

will sum the data on the external sheet "MyFile.xlsx".

You can then view these links on the Data menu, Edit Links.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector