View Single Post
  #1  
Old June 22nd, 2004, 06:05 PM
Mike
external usenet poster
 
Posts: n/a
Default creating hyperlinks to excel bookmarks

I am using Powerpoint 2000 and I want to publish slides to
my company's intranet site. Within my slides I need to
create a number of hyperlinks to various bookmarks within
the spreadsheets.

In the oridnary course of events I would create the
hyperlink: ..\filename.xls#bookmark

Now, when I try using bookmark in the hyperlink wizard
this comes up with an error. So I simply edit my hyperlink
as above. But When I publish the page the "#bookmark"
portion is simply ignored in the output HTML/XML file.

However, within the powerpoint file itself I can still
open the link in another window quite successfully.

Equally, I can edit the offending tag and insert the
#bookmark, save and open the file and it will work.

So, it seems that there is either something I am doing
wrong or there is a bug within the publish function.

Next I saved the spreadsheet as a web page. Not impressed
by the results by the way. All the nicely named bookmarks
had disappeared to be replaced by cell range names. But at
least I could could use the bookmark function in the
hyperlink wizard this time. However, once again when I
published my slide as a web page these anchor points are
still ignored.

As there are up to 20 such links on any given slide and I
have approx 100 slides to produce, I am keen to find a way
around this without having to resort to manual edit of the
html files.

Is this a bug, a feature or is it just my idiocy?