[RESOLVED]HTML page deep link to Cell in Excel sheet

Hi

I am trying to create a hyperlink on a HTML page that will deep link to a Cell on a Sheet in a Excel file.  The example should work but doesnt

<a href="http://localhost/excel/asheet.xls#Sheet2!D4"> This link will open the Excel file to the second page with the focus on cell D4</a>.

I got this example from here http://support.microsoft.com/kb/197922 

When I open the Excel file it seems to highlight the cell I last saved the as and not th ecell in my href

Does it work for you?

Many thanks in advance

Hi,

When u click that link, make sure Excel file is loading with in that browser (IE). but not as a separate Excel application.

Hi Raju

Ahhh that is really helpful, is there anyway I can force the hyperlink to always use the browser to view the file.  Or is this overridden by the client settings on the browser?

many thanks in advance

Hi,

BigMeat

is this overridden by the client settings on the browser?

Yes, it depends on browser settings. Check these sites may help you:

http://support.microsoft.com/kb/162059

http://stackoverflow.com/questions/6293893/how-to-force-pdf-files-to-open-in-browser

Leave a Reply