I'd like to set up a hyperlink from a slide in a Powerpoint 2002 presentation
that opens up a specific worksheet in Excel.
Can anyone help with this please
Right-click on the shape on the slide, select hyperlink. and in the field
provided type
<filename>#<Sheetname>!<cellreference> and then click on OK. Now whenever
you click on the link the excel sheet will open and jump to the set sheet
and cell reference.
example: If the hyperlink is entered as shown below then when you click on
it 'Book1.xls is opened and 'sheet3' is displayed.
c:\windows\desktop\book1.xls#sheet3!A1
A related question: When I hyperlink to open an excel or word doc, the
default window size is full screen. Can this be changed?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
