#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
No one?
Any help would be appreciated. Although I'm leaning toward file corruption. |
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 |
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 |