Results 1 to 14 of 14
  • Thread Tools
  1. Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,452
    Thanks
    22
    Thanked 164 Times in 160 Posts
    I have a large 18MB Excel2010 xlsm file that claims to have a link to one of my other files.

    I have tried lots of things but can't find what is 'linked' or get rid of it.
    Tried all the usual suspects: no formulas, no range names etc
    The Excel 'break link' doesn't break the link.
    Can't use 'change source' to change the link to this file etc.

    Tried downloading a couple of utilities but they couldn't find any links either.
    Does anyone know of a robust link checker????
    Or suggestions?

    Any help always very much appreciated.
    And no, I cannot send the file!

    zeddy

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,927
    Thanks
    11
    Thanked 279 Times in 273 Posts
    MS MVP Bill Manville's Find Links:

    http://www.oaltd.co.uk/DLCount/DLCou...e=FindLink.zip

    Steve

  4. Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,452
    Thanks
    22
    Thanked 164 Times in 160 Posts
    Many thanks - I tried that add-in previously but it didn't resolve the issue.

    I think I have found the source of the anomaly, but still don't have a simple solution for my problem:

    Excel File AAAA has NO links.
    Excel File BBBB is reporting a link to Excel file AAAA
    File BBBB was originally based on a copy of file AAAA.

    If I make a copy of Excel file AAAA in Windows Explorer (e.g. using Ctrl-C, Ctrl-V), and rename this copied file as Excel file CCCC, then when I open file CCCC in Excel it reports a link to file AAAA.

    If I load file AAAA into Excel, and then use file-save-as to save it as file DDDD, then when I subsequently open file DDDD, it does not have any links.

    But this doesn't help me get rid-off the annoying 'link' in file BBBB.

    Still stuck.

    regards

    zeddy


  5. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,927
    Thanks
    11
    Thanked 279 Times in 273 Posts
    Is it possible to strip out the proprietary content, upload the file and let us play with it to see if we can find anything?

    Steve

  6. Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    5,563
    Thanks
    177
    Thanked 675 Times in 613 Posts
    Zeddy,

    In your first post you mentioned it was an .xlsm file indicating Macros {VBA}. Is there something in the VBA that could be causing the link? Just a thought.

    Good Luck.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  7. Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,452
    Thanks
    22
    Thanked 164 Times in 160 Posts
    Hi All

    I will try and strip out stuff and see what I can do.
    Might be a bit tricky, so may have to wait to weekend.
    But I'm sure we are going to discover something interesting!

    zeddy

  8. WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,851
    Thanks
    0
    Thanked 77 Times in 73 Posts
    Any charts in there?
    Regards,
    Rory
    Microsoft MVP - Excel.

  9. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,927
    Thanks
    11
    Thanked 279 Times in 273 Posts
    While charts can lead to links, I have found the FindLinks addin finds these...

    Steve

  10. WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,851
    Thanks
    0
    Thanked 77 Times in 73 Posts
    So have I but nothing is perfect! I don't know whether it can find linked Datalabels for example (the ExecuteExcel4Macro method doesn't work in 2007 - I haven't test in 2010).
    Regards,
    Rory
    Microsoft MVP - Excel.

  11. New Lounger
    Join Date
    Mar 2005
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Links are pretty annoying. I get them all the time.

    The way I locate the link is as follows.

    Go to Find and replace (Control+F)
    Click on Options
    In the find what box put "[" (that's a square box bracket sign)
    Use the drop box to change the within box from "sheet" to "Workbook"
    Click on find all, or find next.

    Hopefully that will find all the linked cells to other worksheets

    Good luck

  12. New Lounger
    Join Date
    Dec 2009
    Location
    Kingsport, TN,USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Most likely there are hidden names and/or links. I use following macro:

    Sub Remove_Hidden_Names()
    ' Module to remove all hidden names on active workbook
    ' This macro provided by Microsoft Tech Support to help
    ' remove hidden links.
    '
    ' Dimension variables.
    Dim xName As Variant
    Dim Result As Variant
    Dim Vis As Variant

    ' Loop once for each name in the workbook.
    For Each xName In ActiveWorkbook.Names

    'If a name is not visible (it is hidden)...
    If xName.Visible = True Then
    Vis = "Visible"
    Else
    Vis = "Hidden"
    End If

    ' ...ask whether or not to delete the name.
    Result = MsgBox(prompt:="Delete " & Vis & " Name " & _
    Chr(10) & xName.Name & "?" & Chr(10) & _
    "Which refers to: " & Chr(10) & xName.RefersTo, _
    Buttons:=vbYesNo)

    ' If the result is true, then delete the name.
    If Result = vbYes Then xName.Delete

    ' Loop to the next name.
    Next xName

    End Sub

    Regard, Ben

  13. New Lounger
    Join Date
    Oct 2010
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    Had a similar issue recently, and vanillaflavour's method, i.e.

    Go to Find and replace (Control+F)
    Click on Options
    In the find what box put "[" (that's a square box bracket sign)

    failed to find the link. I knew that I'd copied in some grouped images from another workbook, and the culprit turned out to be some WordArt that was linked to the original workbook. It's one more possibility.

    Regards,

  14. New Lounger
    Join Date
    Mar 2010
    Location
    austin, texas, usa
    Posts
    7
    Thanks
    0
    Thanked 1 Time in 1 Post
    How about deleting content from the file a bit at a time, save it with a new name, and test it for the Link message. Keep whittling away at the file until the message, hopefully, goes away. Then you might be able to tell what it was.

    Good luck,

    Brian
    Austin, Texas

  15. New Lounger
    Join Date
    Jun 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    same problem

    had the same problem, and it took me a while to find where the link is hiding - a data validation list !!!
    bet you didn't think of that one too...

Posting Permissions

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