Web Development

Ask something
Discussion Locked

Link to 2 diff worksheets same workbook

0 helpful
1 reply

by c. boyd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to create 2 hyperlinks for an intranet web page each of which will open to a different worksheet in the same Excel workbook. I have created labels for each of the A1 cells. So, worksheet 1's A1 is labeled "StepItUp" and worksheet 2's label for A1 is "LightenUp". When I use this it goes to worksheet 2, and when I use to also goes to worksheet 2. I've also tried, where #Step_It_up is the worksheet name and !stepitup is the label for cell A1 on that worksheet. It still goes to worksheet 2. I can't believe there's no way to create two hyperlinks on a webpage each of which goes to a different worksheet in the same workbook. Do you all have the solution?

1 reply

by portypicker

Hi,

This is less an answer, more a confirmation - you should be able to do what you want to do!

You're pretty close I think...

I believe you need to specify a Worksheet and label/cell e.g.

Where Page2 is the name of the worksheet and TheCellB4 is the name given to cell B4 on sheet 2!

So, the second form you have used looks right.
It's possible that the references aren't resolving properly? - Excel's default position is to place you in the workbook at the last place you were when it was last saved. (You could try saving the workbook after 'moving' to a different cell and see where the links take you then?)

MS do say...
"You can open an Excel 97 file to a named area, or any sheet and cell from a anchor link or script in an HTML page as long as the HTML page is accessed via http ( not by double-clicking it in Windows Explorer, nor using file://) and Excel is opened within the browser. If Excel is opened outside of the browser, it will not move to the specified link." (See: http://support.microsoft.com/default.aspx?scid=kb;en-us;197922 )

As you're coming via the Intranet that should be the case? (anyway, I tried it after dbl-clking from WinExp and it worked...?!).
If all else fails... check for typos!
Good Luck...

This discussion is closed to new replies.