Hyperlink to a specific Excel worksheet

  • Thread starter Thread starter Access Joe
  • Start date Start date
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?
 
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
 
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
Click to expand...
 
The #<rangename> option works, but is lost when the file is saved in Office 2007.

Ron
 
Back
Top