can you hyperlink to cells in a excel ss?

D

daneyb

what i a trying to do is create hyperlinks in fp that link back to a excel
cell. what i have got it to do is when i click the link it opens the excel wb
and goes to the last cell i defined a name for.. ex: workbook.xls#abc, but it
will only link back to the last defined cell. is it possible to basicaly do
that for all the cells, mutilply hyperlinks that go to different cells in
the same workbook.. i dont care how it is done..
 
D

daneyb

so i just cant believe that i can hyperlink back to the last cell that i
defined, but i am not able to like back to other defined cells. i mean i am
able to click a hyperlink and it open excel and go to that cell no matter
where it is in the ss. well does anyone have any other alternative methods or
ways i can to this even if thier is other links or programs needed??
 
T

Thomas A. Rowe

You might want to try the Excel newsgroup as this is really not a FP related question.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
S

Stefan B Rusynko

You need to define the workbook#worksheet!namedrange in the link
workbookname.xls#sheetname!rangename

works best if your sheets are named (rather than using defaults such as sheet1, sheet2, etc)



| so i just cant believe that i can hyperlink back to the last cell that i
| defined, but i am not able to like back to other defined cells. i mean i am
| able to click a hyperlink and it open excel and go to that cell no matter
| where it is in the ss. well does anyone have any other alternative methods or
| ways i can to this even if thier is other links or programs needed??
|
| "Teri Carnright" wrote:
|
| > It won't happen - sorry...
| >
| > Teri
| > :)
| >
| >
| > "daneyb" wrote:
| >
| > > what i a trying to do is create hyperlinks in fp that link back to a excel
| > > cell. what i have got it to do is when i click the link it opens the excel wb
| > > and goes to the last cell i defined a name for.. ex: workbook.xls#abc, but it
| > > will only link back to the last defined cell. is it possible to basicaly do
| > > that for all the cells, mutilply hyperlinks that go to different cells in
| > > the same workbook.. i dont care how it is done..
 
Top