Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Linked Workbooks
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba-excel-training - Linked Workbooks
Resolved · Low Priority · Version Standard
Reply Thu 8 Nov 2007, 16:06Delegate Pat said...
For upcoming training course dates see: Pricing & availability
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
|