Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I am using a worksheet that has links to another workbook but i no longer require the link. how do i remove this? I've tried EditLinks, which shows the linked file but there is no options to remove it. thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Newer versions of excel provide an option to break links.
But this'll work in all versions. Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Euan Ritchie wrote: Hi, I am using a worksheet that has links to another workbook but i no longer require the link. how do i remove this? I've tried EditLinks, which shows the linked file but there is no options to remove it. thanks -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Cheers Dave. exactly what was needed!
"Dave Peterson" wrote: Newer versions of excel provide an option to break links. But this'll work in all versions. Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Euan Ritchie wrote: Hi, I am using a worksheet that has links to another workbook but i no longer require the link. how do i remove this? I've tried EditLinks, which shows the linked file but there is no options to remove it. thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linked Workbooks | Excel Discussion (Misc queries) | |||
Comparing and removing data in different workbooks | Excel Worksheet Functions | |||
Linked Workbooks | Excel Discussion (Misc queries) | |||
3 workbooks linked | Excel Discussion (Misc queries) | |||
Removing links to other workbooks-Excel 2000 | Excel Worksheet Functions |