+ Reply to Thread
Results 1 to 12 of 12

Excel file tries to connect to internet links

  1. 05-04-2009, 09:26 AM #1
    Doctorul
    Doctorul is offline
    Registered User
    Join Date
    04-30-2009
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    23

    Excel file tries to connect to internet links

    Hello everybody.

    I'm modifying an older file, created by somebody else and when I open it I keep getting 3 errors telling me that the web links it tries to open are not available. The problem is I've tried everything I could think of to find where/how those links are defined, but with no result.
    The file doesn't seem to have any web query active, no links can be found as part of cell formulas...

    A printscreen is attached below. Is there anyway I can get rid of this type of messages when opening this file?

    Thanks!
    Attached Images Attached Images
    Last edited by Ron Coderre; 05-14-2009 at 03:09 PM. Reason: Marked solved per OP request
    Reply With QuoteRegister To Reply
  2. 05-04-2009, 10:02 AM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel file tries to connect to internet links

    Select Tools / All queries in the workbook / Remove.
    or try this code
    Please Login or Register  to view this content.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 05-05-2009, 01:45 AM #3
    Doctorul
    Doctorul is offline
    Registered User
    Join Date
    04-30-2009
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Excel file tries to connect to internet links

    Thanks for the replay martindwilson, but that didn't help...

    I can't find "All queries in the workbook" in the Tools section of my Excel 2003, so I used the macro, but with no result.

    The same 3 warning messages pop-up when I open the file.
    Reply With QuoteRegister To Reply
  4. 05-05-2009, 07:06 AM #4
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel file tries to connect to internet links

    cant think of anything else! can you just copy the sheets to another new workbook and use that instead?
    Reply With QuoteRegister To Reply
  5. 05-12-2009, 04:02 AM #5
    Doctorul
    Doctorul is offline
    Registered User
    Join Date
    04-30-2009
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Excel file tries to connect to internet links

    Well I did that and it didn't work either.

    In fact, file A is linked to file B. I kept getting the errors while opening file A. If i break the links to file B, I don't recieve the errors anymore, BUT the strange thing is that the file B seems to be ok. When I open it I get nothing. It has no links, no formulas, just values and formatting.
    Don't understand what's wrong. So file A gives me these errors. File A is linked to file B, if I break the links it's ok. If I go to file B (which I shouldn't rename/modify too much) I have no problem there either.

    Any ideas?

    By the way I ran the delete web query macro on both of them with no positive result.
    Reply With QuoteRegister To Reply
  6. 05-12-2009, 08:02 AM #6
    mubashir aziz
    mubashir aziz is offline
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Excel file tries to connect to internet links

    Check File > Properties > Hyperlink Base ......

    May be they have given some link over there !!!!!!!!!!!!
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
    Reply With QuoteRegister To Reply
  7. 05-12-2009, 08:27 AM #7
    Doctorul
    Doctorul is offline
    Registered User
    Join Date
    04-30-2009
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Excel file tries to connect to internet links

    Nothing but a blank field there...
    Reply With QuoteRegister To Reply
  8. 05-12-2009, 11:23 PM #8
    mubashir aziz
    mubashir aziz is offline
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Excel file tries to connect to internet links

    i think after looking original file someone can help you ......
    Reply With QuoteRegister To Reply
  9. 05-13-2009, 10:05 AM #9
    Doctorul
    Doctorul is offline
    Registered User
    Join Date
    04-30-2009
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Excel file tries to connect to internet links

    Quote Originally Posted by mubashir aziz View Post
    i think after looking original file someone can help you ......
    Unfortunately,I can't upload the file because it has some confidential data.Even the links in the error messages are confidential..
    Reply With QuoteRegister To Reply
  10. 05-13-2009, 11:32 PM #10
    mubashir aziz
    mubashir aziz is offline
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Excel file tries to connect to internet links

    Just try to paste function which you have written .... or delete all data from sheets and sent sample file ... Else i'm afrid no one will be able to help u bcoz sometime we have minor error and suffers a lot ......
    Reply With QuoteRegister To Reply
  11. 05-13-2009, 11:58 PM #11
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Excel file tries to connect to internet links

    check range names, conditional formats, data validation. These can contain links to external references that you won't find at first glance in a cell. Also, check macros.
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  12. 05-14-2009, 02:46 AM #12
    Doctorul
    Doctorul is offline
    Registered User
    Join Date
    04-30-2009
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Excel file tries to connect to internet links

    I just looked at the named ranges and found about 100 of them! Most of them contained links, so I deleted all of them and it worked great!
    It never crossed my mind to look at the ranges or the conditional formatting. Thanks a lot teylyn for the solution and also thanks mubashir aziz and martindwilson for your suggestions.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1