Delete a link from an Excel worksheet

  • Thread starter Thread starter Jac Tremblay
  • Start date Start date
J

Jac Tremblay

I created a copy of a worksheet in a new workbook (right-
click on the worksheet name/Copy or Move/Create a copy). I
never really wanted it linked to the source file but it
is. Now, when I open the new workbook, I'm asked if I want
the cells updated. I tried the Links... command in the
Edit menu but it does not offer the option to delete the
link.

What else can I do?

I work with Excel 2000 (French version).

Thank you in advance.
 
Thank you, Paul, for your solution.

Here is how I managed to find the links.

1- I went in the Define Name window (instead of using F5
or Goto) and looked at all the names and their definition.
Some of them were refering to other workbooks. By
correcting those references, the problem was only solved
in part.

2- In each worksheet, I searched for the characters "\"
and/or "[" present in formulas. When they were found, the
formula included a link to another workbook. This is the
best trick I found.

3- I used a macro adapted from one created by John
Walkenbach (excuse the French in it).

'**********************************************************
*********
Sub DeleteHiddenNames()
'
' Fonction DeleteHiddenNames
' Créée par Jac Tremblay le 20
septembre 2003
'
' Macro inspirée de J-Walk (Excel 2002 VBA Programming,
p. 44).
' Cette macro détruit les noms qui ne sont pas visibles
dans un
' chiffrier Excel.
'
Dim n As Name
Dim Count As Integer
Dim strMsg As String
strMsg = ""
For Each n In ActiveWorkbook.Names
If Not n.Visible Then
strMsg = strMsg & n.Name & vbCrLf
n.Delete
Count = Count + 1
End If

Next n
strMsg = strMsg & vbCrLf & "Nombre de noms
supprimés : " & Count
MsgBox strMsg
End Sub

This macro was actually the first thing I tried but did
not solve my problem.

Thank you J-Walk anyway.
-----Original Message-----
I created a copy of a worksheet in a new workbook (right-
click on the worksheet name/Copy or Move/Create a copy).
Click to expand...
I
 
Back
Top