Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Excel Links

Status
Not open for further replies.

Store300

Technical User
Apr 5, 2001
63
GB
Ok, this is getting desperate.

Does anyone know of a way of deleting Excel Links between workbooks?

Preferably through VBA but right now I'll settle for manually hunting the little darling down.

All suggestions gratefully received. :( Store300

Store300@ftnetwork.com
 
Something I do when I am copy sheets from one WB to another where the links to the orignal are retained is to have VBA copy over the sheets, then copy the cell formulas over. This only works if the sheets referenced have the same name. I'll post some code if this is the kind of thing you are looking for, but I don't want to write a long post that won't help. Just put another post in here telling me if this will help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top