Hyperlink to a specific Excel worksheet

A

Access Joe

Hi all,

Using PPT 2003

How can I create a simple hyperlink to Excel that'll go to a specific cell
on a specific worksheet. I.E. My workbook has 20 tabs, and I want it to go
to Sheet 10, Cell B100.

I know how to set a simple hyperlink, and I can have it open the WORKBOOK.
But I tried using the Bookmark button and it won't work - an error comes up
("PPT can not open this file or could not parse this file type").

Any way to do this?
 
G

Geetesh Bajaj

Select the Excel cell, and save it as a range within Excel. And save the
Excel file. Then link to the Excel file, followed by a hash sign, followed by
the name of the range.

For example, if I named the range in Excel to Goodness, I would use this
hyperlink:

C:\paste.xls#Goodness
 
A

Access Joe

PERFECT - thank you!

Geetesh Bajaj said:
Select the Excel cell, and save it as a range within Excel. And save the
Excel file. Then link to the Excel file, followed by a hash sign, followed by
the name of the range.

For example, if I named the range in Excel to Goodness, I would use this
hyperlink:

C:\paste.xls#Goodness
 
R

Ron Carter

The #<rangename> option works, but is lost when the file is saved in Office 2007.

Ron
 

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.

Ask a Question

Top