vba-excel-training - Linked Workbooks

The UK's most regular instructor-led training courses.
Training information: vba-excel-training · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Linked Workbooks

Pat has attended:
Excel Intermediate course

by - delegate Pat [1 post] (2007 Nov 8 Thu, 16:06) Reply

How do you unlink two workbooks?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Linked Workbooks

by - trainer Pete platinum contributer [867 posts] (2007 Nov 15 Thu, 09:26) Reply

Hi Pat, Thank you for your post, In answer to your question there are a number of factors that need to be taken into account: But first how to break the link; Go to Edit - Links, in your Source list select the link you wish to break, if you have more than one link to break press the CTRL key and click each one, then click Break Link.
Now for those things that need to be considered; 1. You may need to remove other objects such as Names (cells or ranges), any Parameter of a query, and consider that the formula will be converted to a value. Hope that helps, regards Pete

· Microsoft Excel's Best Kept Secret
· How to Create Better Excel Spreadsheets: Part Three
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Office and the Small Business: Part 1 Excel
· Excel in the Home Office

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Rate this page: