| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot Table - HT Find source data | Excel Discussion (Misc queries) | |||
| Delete cell on 1 page: automatically delete on another page? | Excel Worksheet Functions | |||
| How to update destination file with source files closed? | Excel Discussion (Misc queries) | |||
| I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
| How can I delete source links and change the current sheet accord. | Excel Worksheet Functions | |||
Linear Mode
