vba-excel-training - linked workbooks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Linked Workbooks

vba-excel-training - Linked Workbooks

resolvedResolved · Low Priority · Version Standard

Pat has attended:
Excel Intermediate course

Linked Workbooks

How do you unlink two workbooks?

RE: Linked Workbooks

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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Server loaded in 0.08 secs.