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?
|