vba-excel-training - 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