TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Office > Microsoft Office Powerpoint

Hyperlink to a specific Excel worksheet

Microsoft Office Powerpoint

 
 
Thread Tools Display Modes
Unread 11-06-2008, 01:24 PM   #1
Access Joe
Guest
 
Posts: n/a
Hyperlink to a specific Excel worksheet

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?
 
Unread 11-06-2008, 04:28 PM   #2
Geetesh Bajaj
Guest
 
Posts: n/a
RE: Hyperlink to a specific Excel worksheet

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

--
Geetesh Bajaj, Microsoft PowerPoint MVP
http://www.indezine.com
http://www.ppted.com


"Access Joe" wrote:

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

 
Unread 11-06-2008, 04:29 PM   #3
Access Joe
Guest
 
Posts: n/a
RE: Hyperlink to a specific Excel worksheet

PERFECT - thank you!

"Geetesh Bajaj" wrote:

> 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
>
> --
> Geetesh Bajaj, Microsoft PowerPoint MVP
> http://www.indezine.com
> http://www.ppted.com
>
>
> "Access Joe" wrote:
>
> > 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?

 
Unread 13-06-2008, 08:23 AM   #4
Geetesh Bajaj
Guest
 
Posts: n/a
RE: Hyperlink to a specific Excel worksheet

Glad this worked for you, and thanks for getting back.
--
Geetesh Bajaj, Microsoft PowerPoint MVP
http://www.indezine.com
http://www.ppted.com


"Access Joe" wrote:

> PERFECT - thank you!
>
> "Geetesh Bajaj" wrote:
>
> > 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
> >
> > --
> > Geetesh Bajaj, Microsoft PowerPoint MVP
> > http://www.indezine.com
> > http://www.ppted.com
> >
> >
> > "Access Joe" wrote:
> >
> > > 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?

 
Unread 26-06-2008, 12:44 PM   #5
ITSolutions
Guest
 
Posts: n/a
RE: Hyperlink to a specific Excel worksheet

Access Joe,

How do you save a cell as a range within Excel?

Thanks.

"Access Joe" wrote:

> PERFECT - thank you!
>
> "Geetesh Bajaj" wrote:
>
> > 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
> >
> > --
> > Geetesh Bajaj, Microsoft PowerPoint MVP
> > http://www.indezine.com
> > http://www.ppted.com
> >
> >
> > "Access Joe" wrote:
> >
> > > 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?

 
Unread 26-06-2008, 12:44 PM   #6
Lucy Thomson
Guest
 
Posts: n/a
Re: Hyperlink to a specific Excel worksheet

Hi

To name a Range, select the cells you want contained within it -> go to the
NameBox -> type the name of your Range (with no spaces) -> hit enter. Or you
can use insert -> name -> define. Named ranges are *really* handy in Excel
as you can refer to them in macros, formulas, navigation, all sorts. For
more info see here:
http://office.microsoft.com/en-us/ex...CH010036991033

Lucy

--
Lucy Thomson
PowerPoint MVP
MOS Master Instructor
www.aneasiertomorrow.com.au


"ITSolutions" <ITSolutions@discussions.microsoft.com> wrote in message
news:EDD34049-6237-4AD1-BF4D-E36BC200D10A@microsoft.com...
> Access Joe,
>
> How do you save a cell as a range within Excel?
>
> Thanks.
>
> "Access Joe" wrote:
>
>> PERFECT - thank you!
>>
>> "Geetesh Bajaj" wrote:
>>
>> > 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
>> >
>> > --
>> > Geetesh Bajaj, Microsoft PowerPoint MVP
>> > http://www.indezine.com
>> > http://www.ppted.com
>> >
>> >
>> > "Access Joe" wrote:
>> >
>> > > 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?



 
Unread 26-06-2008, 12:47 PM   #7
ITSolutions
Guest
 
Posts: n/a
Re: Hyperlink to a specific Excel worksheet

Thanks, Lucy. I really appreciate you taking the time to help out.

"Lucy Thomson" wrote:

> Hi
>
> To name a Range, select the cells you want contained within it -> go to the
> NameBox -> type the name of your Range (with no spaces) -> hit enter. Or you
> can use insert -> name -> define. Named ranges are *really* handy in Excel
> as you can refer to them in macros, formulas, navigation, all sorts. For
> more info see here:
> http://office.microsoft.com/en-us/ex...CH010036991033
>
> Lucy
>
> --
> Lucy Thomson
> PowerPoint MVP
> MOS Master Instructor
> www.aneasiertomorrow.com.au
>
>
> "ITSolutions" <ITSolutions@discussions.microsoft.com> wrote in message
> news:EDD34049-6237-4AD1-BF4D-E36BC200D10A@microsoft.com...
> > Access Joe,
> >
> > How do you save a cell as a range within Excel?
> >
> > Thanks.
> >
> > "Access Joe" wrote:
> >
> >> PERFECT - thank you!
> >>
> >> "Geetesh Bajaj" wrote:
> >>
> >> > 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
> >> >
> >> > --
> >> > Geetesh Bajaj, Microsoft PowerPoint MVP
> >> > http://www.indezine.com
> >> > http://www.ppted.com
> >> >
> >> >
> >> > "Access Joe" wrote:
> >> >
> >> > > 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?

>
>
>

 
Unread 26-06-2008, 12:54 PM   #8
Lucy Thomson
Guest
 
Posts: n/a
Re: Hyperlink to a specific Excel worksheet

No problem :-)

Lucy

--
Lucy Thomson
PowerPoint MVP
MOS Master Instructor
www.aneasiertomorrow.com.au


"ITSolutions" <ITSolutions@discussions.microsoft.com> wrote in message
news:3647303A-33F2-43E0-B4E3-F900D3CF65E5@microsoft.com...
> Thanks, Lucy. I really appreciate you taking the time to help out.
>
> "Lucy Thomson" wrote:
>
>> Hi
>>
>> To name a Range, select the cells you want contained within it -> go to
>> the
>> NameBox -> type the name of your Range (with no spaces) -> hit enter. Or
>> you
>> can use insert -> name -> define. Named ranges are *really* handy in
>> Excel
>> as you can refer to them in macros, formulas, navigation, all sorts. For
>> more info see here:
>> http://office.microsoft.com/en-us/ex...CH010036991033
>>
>> Lucy
>>
>> --
>> Lucy Thomson
>> PowerPoint MVP
>> MOS Master Instructor
>> www.aneasiertomorrow.com.au
>>
>>
>> "ITSolutions" <ITSolutions@discussions.microsoft.com> wrote in message
>> news:EDD34049-6237-4AD1-BF4D-E36BC200D10A@microsoft.com...
>> > Access Joe,
>> >
>> > How do you save a cell as a range within Excel?
>> >
>> > Thanks.
>> >
>> > "Access Joe" wrote:
>> >
>> >> PERFECT - thank you!
>> >>
>> >> "Geetesh Bajaj" wrote:
>> >>
>> >> > 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
>> >> >
>> >> > --
>> >> > Geetesh Bajaj, Microsoft PowerPoint MVP
>> >> > http://www.indezine.com
>> >> > http://www.ppted.com
>> >> >
>> >> >
>> >> > "Access Joe" wrote:
>> >> >
>> >> > > 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?

>>
>>
>>



 
 

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 12:21 PM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional