ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Removing Linked Workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/187538-removing-linked-workbooks.html)

Euan Ritchie

Removing Linked Workbooks
 
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

Removing Linked Workbooks
 
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

Euan Ritchie

Removing Linked Workbooks
 
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



All times are GMT +1. The time now is 07:29 PM.

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