How do I unlink a spreadsheet from another spreadsheet in Excel?

[VBAguy22]

Hello
I "inherrited" a system that creates reports in Excel. It links to other workbooks in Excel, but the link is really unnessecary anymore. How do I un-link them? It is just annoying when it asks at the beginning "Would you like to refresh the link?"

 

[Suggie]

It may be hidden names that are linking to another workbook
Enter the below code into Visual Basic and when you run it it will show if there are any names or links. Just chose delete, if this doesn't work let me know.


Sub DeleteNames()
'
' Delete Names Macro
' Macro recorded 8/21/2003 by rs70724
'

Dim oName As Object
Dim iCount As Integer
For Each oName In ActiveWorkbook.Names
If oName.Visible = False Then
iCount = iCount + 1
If MsgBox("Hidden Name: " & oName.Name & " = " & _
oName.RefersTo & Chr(10) & "Delete?", vbYesNo) = vbYes Then
oName.Delete
End If
End If
Next oName
If iCount = 0 Then MsgBox ("No Hidden Names in " & _
ActiveWorkbook.Name)
End Sub

 

[nberryman]

Try Edit, Links and click the break link button



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[VBAguy22]

i dont think i have a "break link" button

 

[VBAguy22]

oh and I dont have any hidden names (i ran that code), except that the workbook contains over 40 sheets and going through each and every one of them is a pain.

 

[Tiglet]

VBAguy22

Check out this link

thread68-711721

I've used the Microsoft solution myself and it worked a treat

Tiglet

[blue]Living on Earth is expensive, but it does include a free trip around the sun every year.[/blue]