If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
creating hyperlinks to excel bookmarks
It's not you. PPT has a few problems with more specialized types of URLs.
You might want to have a look at our commercial addin for producing HTML from PPT in a more controllable fashion. It's called PPT2HTML, there's a lot more info and a free fully functioning demo at http://ppt2html.pptools.com The current version of the demo won't do what you need it to, since I've only just now added the capability (and thanks for the nudge in that direction). If the addin seems like it'll meet your needs, email me on steve at-sign pptools dot com and I'll send you an updated version to test. Currently it sees a link to e.g. pathfilename.xls#target in the PPT file and converts it to a pathless link to filename.xls#target on the assumption that the linked file will be in the same directory as the html when uploaded to the web server. Links back to your hard drive obviously won't do. ;-) Actually, it should do about the same with any file.ext#target except those that specify a PPT/PPS as the file. In article , Mike wrote: 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? -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
Thread Tools | |
Display Modes | |
|
|