Forum Discussion
No puedo borrar vínculos de un archivo
Hola! Necesito romper el vínculo con un archivo y no puedo, al darle la opción de romper vínculo, me sale la alerta que se convertirán en valores las fórmulas y otra información, pero al darle a...
Hi,
there are a lot of places in Excel where a link could be found. And not in all cases, the link can be broken easily
You should check the following places, where a link to external sources could be found:
- Name manager
- Chart / diagramm (-> "Select Data")
- Pivot table (-> "Change Data Source")
- Shapes (-> right-click, "Remove link")
- FormControls / ActiveX-Controls
- Embedded objects (-> select object and check the link in the formular bar
- Data validation
- Conditional formatting rules
There might be some other places, but the listed ones are the most common ones.
Hope this helps a bit.
there are a lot of places in Excel where a link could be found. And not in all cases, the link can be broken easily
You should check the following places, where a link to external sources could be found:
- Name manager
- Chart / diagramm (-> "Select Data")
- Pivot table (-> "Change Data Source")
- Shapes (-> right-click, "Remove link")
- FormControls / ActiveX-Controls
- Embedded objects (-> select object and check the link in the formular bar
- Data validation
- Conditional formatting rules
There might be some other places, but the listed ones are the most common ones.
Hope this helps a bit.