Error opening hyperlinks in Excel 2003

Posted by richardtallent on Super User See other posts from Super User or by richardtallent
Published on 2010-03-31T17:37:19Z Indexed on 2010/03/31 17:43 UTC
Read the original article Hit count: 621

Filed under:

excel

|

hyperlinks

|

browser

When clicking to follow hyperlinks from Excel, I'm now getting this error:

Unable to open http://blah... Cannot download the information you requested.

The hyperlinks in the Excel file are created using the HYPERLINK() formula.

I use Google Chrome as my default browser. The web site in question uses Basic Authentication, and I've entered correct credentials when prompted (the dialog looked like an IE auth box, not Chrome's, but it's always been that way, even when it was working properly).

This hasn't been an issue until recently. I'm guessing our IT department made some lame change to IE's configuration that is causing Office to not be able to open the URLs, despite having Chrome as my browser.

Things I've checked already:

URLs are good, they work fine when pasted manually into Chrome, IE, or Firefox.
IE is not set to Work Offline (already found that suggestion on Google).
I checked Program Access and Defaults and verified that Chrome is selected.
Nothing in the URL requires URLEncoding, so it's no goofy issue with encoding

I've had reports from some other users now and then about the same problem, but this is the first time I've experienced it myself.

© Super User or respective owner

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More

Related posts about hyperlinks

Convert Plain Text Hyperlinks into HTML Hyperlinks in PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a simple commenting system here... http://affbuzz.com/comments/7299a55137def55917a5dc6c4fe0f261af8a4217 ...and people can submit hyperlinks inside the plain text field. When I display these records back from the database and into the web page, what RegExp in PHP can I use to convert these… >>> More
Microsoft Entrourage: rendering hyperlinks?

as seen on Stack Overflow - Search for 'Stack Overflow'
When we send emails from my project, we send in both text/plain and text/html formats. All major clients (gmail, yahoo, hotmail, thunderbird, outlook) correctly display the simple HTML that we are using. However, Entourage renders all tags EXCEPT hyperlinks. What is confusing is that emails from other… >>> More
Extract hyperlinks from .doc

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, Is there any way to extract hyperlinks from .doc. I got bunch of hyperlinks in doc that I need to import in my database. I have tried converting doc to HTML, but hyperlinks are not transferred. Regardz, Mladen >>> More
How To Remove Hyperlinks from Microsoft Word Documents

as seen on How to geek - Search for 'How to geek'
Sometimes when you copy text from a webpage and paste it into Word, it can be annoying when the hyperlinks transfer with it. Today we take a look at how to easily remove the hyperlinks if you don’t want them in the document. Here we will cover a few different ways you can remove hyperlinks from emails… >>> More
How do I use Powershell to print a list of hyperlinks that appear in a Word document?

as seen on Stack Overflow - Search for 'Stack Overflow'
I asked this question last week, and my script cannot find any hyperlinks to change. Now I'm backing up and trying to simply open a single document and list the hyperlinks within. I've verified that the document includes hyperlinks to a number of anchors in the same document, and two hyperlinks to… >>> More