Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
SLP SLP is offline
external usenet poster
 
Posts: 58
Default Disconnect linked file

I have a workbook that when it is opened asks if I want to update the link.
How do I remove the link as there shouldn't be one? I went to Edit | Links
but delete is not an option there. Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 180
Default Disconnect linked file

You are using the right option, however use the option called 'Break links'
it will remove all the links from your workbook.

Regards,
Pranav Vaidya

"SLP" wrote:

I have a workbook that when it is opened asks if I want to update the link.
How do I remove the link as there shouldn't be one? I went to Edit | Links
but delete is not an option there. Thanks in advance.

  #3   Report Post  
Posted to microsoft.public.excel.misc
SLP SLP is offline
external usenet poster
 
Posts: 58
Default Disconnect linked file

I don't have a break links option available.

"SLP" wrote:

I have a workbook that when it is opened asks if I want to update the link.
How do I remove the link as there shouldn't be one? I went to Edit | Links
but delete is not an option there. Thanks in advance.

  #4   Report Post  
Posted to microsoft.public.excel.misc
SLP SLP is offline
external usenet poster
 
Posts: 58
Default Disconnect linked file

I opened the workbook in a different version of Excel and the break link
option was then available. Thanks.

"SLP" wrote:

I don't have a break links option available.

"SLP" wrote:

I have a workbook that when it is opened asks if I want to update the link.
How do I remove the link as there shouldn't be one? I went to Edit | Links
but delete is not an option there. Thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked pdf file Chris Links and Linking in Excel 1 February 4th 07 04:40 PM
Linked File Calcuation req. source file to be open smcd Excel Discussion (Misc queries) 1 April 19th 06 03:09 AM
In a linked calculation how do I lose the '0' in the linked file? Anita Excel Worksheet Functions 2 February 3rd 06 01:54 PM
linking a file to another linked file in excel buckeye Excel Discussion (Misc queries) 1 November 10th 05 12:53 AM
How do I break a linked file Floridagal Excel Discussion (Misc queries) 4 August 3rd 05 11:08 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"