canceling links between workbooks

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,940
I am keeping to get a message whenever I open one of my workbooks telling me that this workbook has automatic link to other workbook etc.
This happend after I copied some material from this workbook to another. But really I did not intended to link between them.
How can I find and cancel the link if it exsists at all?
Eli
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Hit Edit-Links to see if it's linking to external files.

Hit Insert-Name-Define and see if any named ranges are pointing to external references.
 
Upvote 0
On 2002-03-06 04:52, Dreamboat wrote:
Hit Edit-Links to see if it's linking to external files.

Hit Insert-Name-Define and see if any named ranges are pointing to external references.
Thank you Dreamboat
Yes it's really links to an external file which no longer exsists
How can I get rid of the link?
Eli
 
Upvote 0
On 2002-03-06 13:58, Chris Davison wrote:
sorry Barrie, I think I must have missed that original reply

no offence mate
/board/images/smiles/icon_smile.gif

Absolutely none taken (no big ego here - no room for egos with this many smart people on the board).
:)
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top