Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Linking workbooks

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel training - Linking workbooks

Resolved · Low Priority · Version Standard

Reply Thu 20 Dec 2007, 17:00Delegate Ashpal said...

Ashpal has attended:
Excel Intermediate course
Excel Advanced course

Linking workbooks

How do you update links within a workbook that has been linked to another workbook without manually having to update each cell?

For upcoming training course dates see: Pricing & availability

Reply Wed 2 Jan 2008, 09:56Trainer Rajeev said...

RE: Linking workbooks

Dear Ashpal

Thank you for attending Excel Intermediate course.

Please note that if you have linked the two files then they should automatically update without you having to do anything.

When you link two workbooks together you have the Source file (This is the file where the original data is COMING FROM) and the destination file (The file where the data is GOING TO).

If the Source file is closed and you try to open the Destination file then a message is displayed informing you that the file has external links and you are given the option of updating or not updating the file.

But if both the Source and Destination files are open and you change the data in the Source file then the cells in the Destination file automatically update.

I hope this helps. If you need further clarification or may have a work based scenario then please post your question and I

Excel articles

· Make Things Easier In Excel With Lists
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· Copy And Paste In Excel
· Improving Navigation Of Your Worksheets In Excel
· How To Add A Second Axis To An Excel Line Chart

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips