+ Reply to Thread
Results 1 to 2 of 2

Cannot break links between 2 workbooks

  1. #1
    Registered User
    Join Date
    11-29-2007
    Posts
    12

    Cannot break links between 2 workbooks

    Hi! I copied 3 pages from one workbook to another. When I open either, I get the message that they are linked. Nothing happens when I try to break those links. If I open both, the Break Links option is grayed out. Help!

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: Cannot break links between 2 workbooks

    Hi
    One way is locate the cell where is the formula that links to the other worksheet and remove the workbook / worksheet name from that formula
    Use Find command to find the cells
    Thanks
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Edit Links - Break Links not working
    By dmang1 in forum Excel General
    Replies: 10
    Last Post: 03-16-2017, 12:43 PM
  2. Completely remove/delete all the external links (Break Links)
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 05:31 AM
  3. [SOLVED] Break links of a number of workbooks to master workbook
    By juansn in forum Excel General
    Replies: 1
    Last Post: 08-08-2013, 10:20 AM
  4. Break all links in all workbooks in a folder
    By jharaldson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 08:56 PM
  5. break links
    By keith6292 in forum Excel General
    Replies: 2
    Last Post: 12-12-2009, 04:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1