Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2017, 01:28 PM
YounesB3 YounesB3 is offline Unable to open http link Windows XP Unable to open http link Office 2010 32bit
Advanced Beginner
Unable to open http link
 
Join Date: Jul 2012
Posts: 37
YounesB3 is on a distinguished road
Default Unable to open http link

I had several pop-ups with the following message "Unable to open http:\\ The internet site reports that the item you requested could not be found. (HTTP/1.0 404)"

I cleaned up the file, which had broken links from early 2000s, by cleaning-up the following:
- Formulas from the Name Manager (I also cleaned-up the hidden ones by running a macro to show ALL of them);
- Conditional formatting from all worksheets including hidden ones;
- Data validation from all worksheets including hidden ones;
- Old connections which weren't necessary anymore.

This removed all but one link which still pop-ups when I open the file. There is one adequate remaining connection. When I remove the connection, the pop-up disappears. So I thought the other file might be the problem. I cleaned-up the other file by doing the same process as above. The problem remained.... I then proceeded to identify where were the links being made with the file by searching ".xl" in all workbooks. It all comes down to only 8 formulas. The problem is that these formulas have no errors and are a simple IF+VLOOKUP. I checked the results of these formulas and they all make sense. Nonetheless, when I remove those 8 cells, the pop-up disappears. So I thought the file might be corrupted. I then proceeded to remove those 8 cells, save the file, closing it, and reputing the same links afterward. After I put the formulas in these cells, the pop-up reappears again....

The thing is, the URL pop-up message still showing has absolutely no tie with these 8 cells and it talks about a link from 2014....



What's up with that?

Cross-reference: https://www.mrexcel.com/forum/excel-...1-0-404-a.html
Reply With Quote
  #2  
Old 11-13-2017, 07:54 AM
YounesB3 YounesB3 is offline Unable to open http link Windows XP Unable to open http link Office 2010 32bit
Advanced Beginner
Unable to open http link
 
Join Date: Jul 2012
Posts: 37
YounesB3 is on a distinguished road
Default

No one?

Any help would be appreciated.

Although I'm leaning toward file corruption.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook unable to understand the mobile app link pooja13pandey Outlook 0 05-23-2017 09:39 AM
Unable to open Outlook, receiving message unable to open because (myaccount)@gmail.c Flyin' Aces Tattoo Outlook 0 04-20-2013 11:56 AM
Unable to open http link Word unable to open email link jima59 Word 1 05-11-2012 04:40 PM
All hyperlinks in outlook open up in internet explorer as "http://%22/". kandiyohiv Outlook 0 01-02-2012 11:30 AM
Word is unable to create a link to the object you specified. Please insert the... broscup Word Tables 1 06-28-2011 11:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft