Linking workbooks

Resolved · Medium Priority · Version 2010

Tue 17 Sep 2013, 16:26 Delegate Genta said...

Genta has attended:
Excel Advanced course

Linking workbooks

how to link 2 workbooks

Wed 18 Sep 2013, 16:36 Trainer Gary said...

RE: 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

Wed 25 Sep 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips