ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I delete a source ? (https://www.excelbanter.com/excel-discussion-misc-queries/125394-how-do-i-delete-source.html)

leifvn

How do I delete a source ?
 
I open a worksheet, and get a box saying "Workbook contains links to other
sources". I click "Update", and then "Edit links". The Edit links box comes
up. One line says "Budget.xls Error: Source not found". It can't be
found, because I deleted it long ago. How do I delete this line without
screwing something up? I suspect this error is causing Excel to misbehave.
I am using Windows XP.

Ron de Bruin

How do I delete a source ?
 
Hi leifvn

Have you try EditLinks and use break

With code you can try this
http://www.rondebruin.nl/values.htm#break

See the last macro on this page


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"leifvn" wrote in message ...
I open a worksheet, and get a box saying "Workbook contains links to other
sources". I click "Update", and then "Edit links". The Edit links box comes
up. One line says "Budget.xls Error: Source not found". It can't be
found, because I deleted it long ago. How do I delete this line without
screwing something up? I suspect this error is causing Excel to misbehave.
I am using Windows XP.



All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com