como eliminar un vinculo a un archivo eliminado en Excel

1.  Lo primero que deberías hacer es intentar borrando/suistituyendo la referencia al libro eliminado dentro de la(s) formula(s) en el archivo existente que usa(n) tal referencia.

Si el problema esta en que no consigues encontrar esta(s) celda(s), entonces podrías hacer lo siguiente:

2.  Buscar los vínculos a mano prestando especial atención a

todas las celdas de cada hoja que contengan formulas. Puedes seleccionar todas las celdas con formulas de una hoja mediante el menú Edición>Ir a..., botón 'Especial', opción 'Formulas', Aceptar y luego navegar por área seleccionado mediante la tecla 'Tab'

-   hojas ocultas (menú Formato>Hoja>Mostrar...)

- nombres definidos (menú Insertar>Nombre>Definir...) examinando las formulas de cada uno de los nombres

- graficos (clic derecho sobre el gráfico, opcion 'Datos de origen') examinando las referencias a los datos de origen

- tablas dinamicas (clic derecho sobre la tabla, opcion 'Asistente', boton: Atras) examinando las referencias a los datos de origen

3. Instalar y usar el complemento FindLink.xla de Bill Manville: http://www.bmsltd.ie/MVP/MVPPage.asp#BillManville

- bajar el archivo FindLink.zip

- descomprimir el archivo FindLink.xla en una carpeta

- desde el Excel ir al menú Herramientas>Complementos...

- pulsar el botón 'Examinar' y encontrar la carpeta y el archivo FindLink.xla

- pulsar el botón 'Aceptar'

- pulsar el botón 'Aceptar'

- abrir el archivo con vínculos e ir al menú Herramientas>Find Links

- Seguir las instrucciones

FINDLINK

Purpose

This popular utility is an Excel add-in which searches a workbook for a specified string (usually representing a link to another workbook) and tells you where in the workbook it occurs, optionally replacing formulas that include the string with their current values.

It can thus be used to find out why you are unexpectedly getting a message like this on opening the workbook
.
and, by replacing the formulas that contain the links with their values it can prevent the message from appearing in future.

Installation

• The current version is 10.2  Download it here
• Extract FindLink.xla from the zip file to a folder on your computer
• You can choose whether to install FindLink as an add-in so that it is available whenever you are running Excel or whether to just open it when you want to use it.
• To install as an add-in, in Excel 2003 or earlier:
  • Tools > Add-Ins > Browse to where you saved FindLink.xla, Select FindLink.xla and click OK
• To install as an add-in in Excel 2007
  • Office Button > Excel Options > Add-Ins > Manage: Excel Add-Ins > Go > Browse to where you saved FindLink.xla, Select FindLink.xla and click OK
• To install as an add-in in Excel 2010 or 2013
  • File > Options > Add-Ins > Manage: Excel Add-Ins > Go > Browse to where you saved FindLink.xla, Select FindLink.xla and click OK
• To run it once without installing it as an add-in:
  • In Excel 2007: Office Button > Open > FindLink.xla
  • In other versions, File > Open > FindLink.xla
  • If you are warned about the presence of macros in the file, enable the content.
  • If you are offered the opportunity to trust the publisher (Bill Manville Associates), do so.

Use

• FindLink adds a "Find Links" menu item to the Tools menu in Excel (up to 2003) or in the Add-Ins ribbon (in 2007 and later)
• Click the Find Links menu item, and FindLink displays a dialog:
  
          
• Usually FindLink is asked to find a particular filename to which there are links in the workbook, or ".xl" to find links to any Excel files
• It looks through the active workbook for formulas that include a string specified by the user. It looks in defined names, cell formulas and also in any objects which can be linked to data in cells (e.g. chart series, data labels, textboxes, data validation lists, conditional formatting formulas).
• There are options make a list in a worksheet of everywhere that the specified string was found, and/or to remove all occurrences of the string (e.g. by replacing formulas with values) or to give a message for each occurrence, allowing the user to decide on an action:
  
       
• Note: If you are looking for links to an installed add-in they will not be found unless you either de-install the add-in or launch Excel in Safe mode (hold down Ctrl key while starting Excel) to prevent the add-infrom loading. If you use Safe mode you would then need to open FINDLINK explicitly.

What's new

• Version 10.2 works when file names contain ' and also when pivottables are connected to external data sources such as PowerQuery
• Version 10.0 improves the searching of conditional formatting formulas to include ColorScales, DataBars and IconSets
• Version 9.9a has an updated email address for support and error reporting
• Version 9.9 finds links in additional conditional formatting formulas (Excel 2007 and later)
• Version 9.7 works better on Mac versions of Excel
• Version 9.6 finds links in cells hidden by filtering
• Version 9.5 handles axis titles better in Excel 2010

Known deficiencies

Due to limitations in the VBA object model, links will not be found in:

• Titles of secondary axes in charts
• Sources of custom error bars in charts
• Rows hidden by advanced filtering