![]() |
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. |
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