+ Reply to Thread
Results 1 to 9 of 9

'Refresh all' - error for external link that is not excisting

  1. #1
    Registered User
    Join Date
    05-05-2017
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2016
    Posts
    15

    'Refresh all' - error for external link that is not excisting

    Hi 'Exc-all',

    My spreadsheet doesn't have links to external data. Als if I search into all formula's to ".xls", Excel doesn't find anything. But somehow if I 'refresh all' data I get the error that it cannot find an external spreadsheet. The link Excel is searching is an old tab of a previous version of this document. But again, this Excel doesn't have any links to external data.

    Is anyone familiair with solving such an issue/error.

    TIA!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    10,918

    Re: 'Refresh all' - error for external link that is not excisting

    Have you tried editing links via the option on the data ribbon?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-05-2017
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2016
    Posts
    15

    Re: 'Refresh all' - error for external link that is not excisting

    Thanks for you quick respons.

    But this option is not highlighted and thus I cannot click on it

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    10,918

    Re: 'Refresh all' - error for external link that is not excisting

    Can you attach the workbook here?

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  5. #5
    Registered User
    Join Date
    05-05-2017
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2016
    Posts
    15

    Re: 'Refresh all' - error for external link that is not excisting

    Plesase see the attachement.

    Now I actually can click on the 'editing links', but I cannot change or remove the link...

    Very anoying!!

    Hope you'll have a great tip...

    TIA
    Attached Files Attached Files

  6. #6
    Forum Expert xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    4,340

    Re: 'Refresh all' - error for external link that is not excisting

    Hi,

    You have data validation rules in columns E and H on the Personeelslijst sheet that refer to the missing workbook.
    Please remember to mark your thread 'Solved' when appropriate.

  7. #7
    Registered User
    Join Date
    05-05-2017
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2016
    Posts
    15

    Re: 'Refresh all' - error for external link that is not excisting

    Wow, thank you very much!!!
    How did you find it? Did you find it by a special search?

    Thanks again!

  8. #8
    Forum Expert xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    4,340

    Re: 'Refresh all' - error for external link that is not excisting

    The most likely causes, besides formulas or data connections, were defined names, data validation or conditional formatting, so I applied brute force - deleting each sheet in turn until the edit links dialog was disabled, then searching the offending sheet for the likely options.

  9. #9
    Registered User
    Join Date
    05-05-2017
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2016
    Posts
    15

    Re: 'Refresh all' - error for external link that is not excisting

    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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