Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / March 2008

Tip: Looking for answers? Try searching our database.

Hyperlink help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bob278 - 14 Mar 2008 22:30 GMT
I have a small website that uses files from a web development package
Word docs and Excel spreadsheets saved in htm files.  I link from on
to the other but my spreadsheets now have multiple worksheets in the
and the links form Word only go to the first tab/worksheet.

I go into the hyperlink feature and choose Existing File or Webpage an
enter the url for my spreadsheet,  Is there a way to modify the url
enter so that the link takes me to a worksheet other than the firs
one?

Thanks for your help

--
bob278
Bill Manville - 15 Mar 2008 09:21 GMT
To open the workbook at Sheet3!Z99 append #Sheet3!Z99  to the hyperlink
address.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
bob278 - 15 Mar 2008 17:10 GMT
Bill Manville;2674912 Wrote:
> To open the workbook at Sheet3!Z99 append #Sheet3!Z99  to the hyperlink
> address.
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Thank you Bill.  Here is the entry I made in the address field.  Even
though the url shown in the browser address field included this
information, it opened the file at the first sheet.  It opens exactly
the same with or without the text after "htm".  I'm sure this is
operator error, but I don't know what I am doing wrong.  My browser is
Firefox but I've also tried it on my wife's computer with IE.  We both
have Windows Vista.  Any suggestions?  Thank you again.

As entered in Word  [http://tinyurl.com/yo39mk

As displayed in browser
http://tinyurl.com/yo39mk

Signature

bob278

Bill Manville - 16 Mar 2008 00:39 GMT
Hmm.
You have me confused.
I thought you were linking to an Excel workbook but you seem to be
linking to a .htm file.  And the 2 URLs you gave me seem to be
identical.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
bob278 - 16 Mar 2008 04:56 GMT
Bill,  I was afraid I might confuse you.  What I was trying to say was
that I put a url in the hyperlink address in the word doc and it did
link to the url as I entered it, but ignored everything after the
"htm".

What I have is a Word doc that I save as a webpage.  Within that page,
I have links to the spreadsheet that I also save as a webpage.  I ftp
both of them to a webhost for access, along with several other files.

In the Word doc, I want to link to the spreadsheet and that works.  But
it goes to what ever sheet happened to be open when the spreadsheet was
saved.  I need for it to go to a particular sheet depending on which
link was selected.  In the "source" page, http://tinyurl.com/yoytk4

the top cabin link (7172) should go to deck7 tab in the spreadsheet and
the next one down (9594) should go to the deck9 tab. Both go to the
index tab as that is what was active when I saved it.  The spreadsheet
url is: http://tinyurl.com/256omk

You have no idea how grateful I am that you are trying to help me.  My
alternative is to have an individual spreadsheet saved as htm for all
the tabs and maintaining 9 files is far more trouble than just one.  I
sure hope what I want to do is possible.  I need to be able to do this
using the functionality built in as I do not know vb programming.

Thank you so much.

Signature

bob278

Bill Manville - 16 Mar 2008 09:36 GMT
Hi Bob

If the person reading the webpage has Excel then your link could be to
the XLS file with the sheet!range as a sub-address and the workbook
would be opened by Excel operating within the browser showing the
correct sheet (at least for Internet Explorer; I have no knowledge of
others).

But I guess you can't rely on the reader having suitable software.
I don't think you can avoid saving individual worksheets as separate
html files and linking to each such file separately.

But I am not an expert in the html area

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
bob278 - 16 Mar 2008 16:09 GMT
Bill,

I was afraid of that.  Since the url does not change depending on the
sheet that gets opened, I guess the entire multi-sheet spreadsheet is
one file with internal links.

I appreciate all the time you took to try to help with this.

Signature

bob278


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.