|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Just keep in mind that the XL file must first be saved for linking to
stick.
AND, don't move your files or your links will break.
Brian Reilly, MVP
On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
wrote:
>John:
>
>PERFECT!
>Just what I was looking for!
>Thank you!!!!!!
>
>SRS
>
>"John Fallon" wrote:
>
>> In Microsoft Excel, select the range of cells you want to link, and then
>> click Copy.
>> Switch to Microsoft PowerPoint, and then click the slide or notes page where
>> you want to insert the linked copy of worksheet cells.
>> On the Edit menu, click Paste Special.
>> Click Paste link.
>> Hope this helps!!!
>> --
>> John Fallon
>> Instructional Technology Evangelist for PPT4Teachers.com
>> Where Instruction and Technology meet for Teachers and the Classroom
>> http://www.ppt4teachers.com
>>
>>
>> "SRS" wrote:
>>
>> > I have a map of the USA in a PPT presentation and a text box placed in each
>> > state. Once a month, I receive an excel spreadsheet with sales data for each
>> > state. Is there a way to link the text boxes with the excel spreadsheet so
>> > the data will update automatically instead of me having to go into each
>> > state, each month, and update manually?
>> >
>> > Thank you!
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
I did the above suggestions to link Excel worksheets to Powerpoint which
works when I'm in Normal view in Ppt. However, when I'm in Slideshow view,
the links don't work. You say the Excel file must be saved for linking to
stick? What does this mean/how do I do that?
"Brian Reilly, MVP" wrote:
> Just keep in mind that the XL file must first be saved for linking to
> stick.
>
> AND, don't move your files or your links will break.
>
> Brian Reilly, MVP
>
> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> wrote:
>
> >John:
> >
> >PERFECT!
> >Just what I was looking for!
> >Thank you!!!!!!
> >
> >SRS
> >
> >"John Fallon" wrote:
> >
> >> In Microsoft Excel, select the range of cells you want to link, and then
> >> click Copy.
> >> Switch to Microsoft PowerPoint, and then click the slide or notes page where
> >> you want to insert the linked copy of worksheet cells.
> >> On the Edit menu, click Paste Special.
> >> Click Paste link.
> >> Hope this helps!!!
> >> --
> >> John Fallon
> >> Instructional Technology Evangelist for PPT4Teachers.com
> >> Where Instruction and Technology meet for Teachers and the Classroom
> >> http://www.ppt4teachers.com
> >>
> >>
> >> "SRS" wrote:
> >>
> >> > I have a map of the USA in a PPT presentation and a text box placed in each
> >> > state. Once a month, I receive an excel spreadsheet with sales data for each
> >> > state. Is there a way to link the text boxes with the excel spreadsheet so
> >> > the data will update automatically instead of me having to go into each
> >> > state, each month, and update manually?
> >> >
> >> > Thank you!
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
What do you mean, the links don't work in slide show view? Are you trying to
click the cells and open an Excel workbook during a presentation? If so,
that's different than the kind of links Brian and John are describing.
--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
"kal4000" <kal4000@discussions.microsoft.com> wrote in message
news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
>I did the above suggestions to link Excel worksheets to Powerpoint which
> works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> view,
> the links don't work. You say the Excel file must be saved for linking to
> stick? What does this mean/how do I do that?
>
> "Brian Reilly, MVP" wrote:
>
>> Just keep in mind that the XL file must first be saved for linking to
>> stick.
>>
>> AND, don't move your files or your links will break.
>>
>> Brian Reilly, MVP
>>
>> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
>> wrote:
>>
>> >John:
>> >
>> >PERFECT!
>> >Just what I was looking for!
>> >Thank you!!!!!!
>> >
>> >SRS
>> >
>> >"John Fallon" wrote:
>> >
>> >> In Microsoft Excel, select the range of cells you want to link, and
>> >> then
>> >> click Copy.
>> >> Switch to Microsoft PowerPoint, and then click the slide or notes page
>> >> where
>> >> you want to insert the linked copy of worksheet cells.
>> >> On the Edit menu, click Paste Special.
>> >> Click Paste link.
>> >> Hope this helps!!!
>> >> --
>> >> John Fallon
>> >> Instructional Technology Evangelist for PPT4Teachers.com
>> >> Where Instruction and Technology meet for Teachers and the Classroom
>> >> http://www.ppt4teachers.com
>> >>
>> >>
>> >> "SRS" wrote:
>> >>
>> >> > I have a map of the USA in a PPT presentation and a text box placed
>> >> > in each
>> >> > state. Once a month, I receive an excel spreadsheet with sales data
>> >> > for each
>> >> > state. Is there a way to link the text boxes with the excel
>> >> > spreadsheet so
>> >> > the data will update automatically instead of me having to go into
>> >> > each
>> >> > state, each month, and update manually?
>> >> >
>> >> > Thank you!
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Yes, I have icons that I want to be able to click on during my powerpoint
presentation which will bring me to the Excel workbook. Is this possible?
How do I go about doing it? Thanks.
"Echo S" wrote:
> What do you mean, the links don't work in slide show view? Are you trying to
> click the cells and open an Excel workbook during a presentation? If so,
> that's different than the kind of links Brian and John are describing.
>
> --
> Echo [MS PPT MVP] http://www.echosvoice.com
> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>
>
>
> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> >I did the above suggestions to link Excel worksheets to Powerpoint which
> > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> > view,
> > the links don't work. You say the Excel file must be saved for linking to
> > stick? What does this mean/how do I do that?
> >
> > "Brian Reilly, MVP" wrote:
> >
> >> Just keep in mind that the XL file must first be saved for linking to
> >> stick.
> >>
> >> AND, don't move your files or your links will break.
> >>
> >> Brian Reilly, MVP
> >>
> >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> >> wrote:
> >>
> >> >John:
> >> >
> >> >PERFECT!
> >> >Just what I was looking for!
> >> >Thank you!!!!!!
> >> >
> >> >SRS
> >> >
> >> >"John Fallon" wrote:
> >> >
> >> >> In Microsoft Excel, select the range of cells you want to link, and
> >> >> then
> >> >> click Copy.
> >> >> Switch to Microsoft PowerPoint, and then click the slide or notes page
> >> >> where
> >> >> you want to insert the linked copy of worksheet cells.
> >> >> On the Edit menu, click Paste Special.
> >> >> Click Paste link.
> >> >> Hope this helps!!!
> >> >> --
> >> >> John Fallon
> >> >> Instructional Technology Evangelist for PPT4Teachers.com
> >> >> Where Instruction and Technology meet for Teachers and the Classroom
> >> >> http://www.ppt4teachers.com
> >> >>
> >> >>
> >> >> "SRS" wrote:
> >> >>
> >> >> > I have a map of the USA in a PPT presentation and a text box placed
> >> >> > in each
> >> >> > state. Once a month, I receive an excel spreadsheet with sales data
> >> >> > for each
> >> >> > state. Is there a way to link the text boxes with the excel
> >> >> > spreadsheet so
> >> >> > the data will update automatically instead of me having to go into
> >> >> > each
> >> >> > state, each month, and update manually?
> >> >> >
> >> >> > Thank you!
> >>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
In article <CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com>, Kal4000 wrote:
> Yes, I have icons that I want to be able to click on during my powerpoint
> presentation which will bring me to the Excel workbook. Is this possible?
> How do I go about doing it? Thanks.
Try adding an action setting, Hyperlink to:, Other file and pick your XLS file.
When you click on the link during a slide show, PPT will launch the XLS file.
Depending on version and your settings, it may insist on displaying a warning
message about viruses and stuff before it lets you launch the XLS file.
There's a fix for that, at least on your own PC.
"Some files can contain viruses ..." message when clicking a hyperlink
http://www.pptfaq.com/FAQ00406.htm
>
> "Echo S" wrote:
>
> > What do you mean, the links don't work in slide show view? Are you trying to
> > click the cells and open an Excel workbook during a presentation? If so,
> > that's different than the kind of links Brian and John are describing.
> >
> > --
> > Echo [MS PPT MVP] http://www.echosvoice.com
> > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> >
> >
> >
> > "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> > news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> > >I did the above suggestions to link Excel worksheets to Powerpoint which
> > > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> > > view,
> > > the links don't work. You say the Excel file must be saved for linking to
> > > stick? What does this mean/how do I do that?
> > >
> > > "Brian Reilly, MVP" wrote:
> > >
> > >> Just keep in mind that the XL file must first be saved for linking to
> > >> stick.
> > >>
> > >> AND, don't move your files or your links will break.
> > >>
> > >> Brian Reilly, MVP
> > >>
> > >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> > >> wrote:
> > >>
> > >> >John:
> > >> >
> > >> >PERFECT!
> > >> >Just what I was looking for!
> > >> >Thank you!!!!!!
> > >> >
> > >> >SRS
> > >> >
> > >> >"John Fallon" wrote:
> > >> >
> > >> >> In Microsoft Excel, select the range of cells you want to link, and
> > >> >> then
> > >> >> click Copy.
> > >> >> Switch to Microsoft PowerPoint, and then click the slide or notes page
> > >> >> where
> > >> >> you want to insert the linked copy of worksheet cells.
> > >> >> On the Edit menu, click Paste Special.
> > >> >> Click Paste link.
> > >> >> Hope this helps!!!
> > >> >> --
> > >> >> John Fallon
> > >> >> Instructional Technology Evangelist for PPT4Teachers.com
> > >> >> Where Instruction and Technology meet for Teachers and the Classroom
> > >> >> http://www.ppt4teachers.com
> > >> >>
> > >> >>
> > >> >> "SRS" wrote:
> > >> >>
> > >> >> > I have a map of the USA in a PPT presentation and a text box placed
> > >> >> > in each
> > >> >> > state. Once a month, I receive an excel spreadsheet with sales data
> > >> >> > for each
> > >> >> > state. Is there a way to link the text boxes with the excel
> > >> >> > spreadsheet so
> > >> >> > the data will update automatically instead of me having to go into
> > >> >> > each
> > >> >> > state, each month, and update manually?
> > >> >> >
> > >> >> > Thank you!
> > >>
> >
>
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Thanks. I did the same thing to 3 icons that I have, and one of them works
great, opening the Excel workbook, while the other two give me a box that
says "Cannot open the specified file". Do you know how to fix this problem?
"Steve Rindsberg" wrote:
> In article <CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com>, Kal4000 wrote:
> > Yes, I have icons that I want to be able to click on during my powerpoint
> > presentation which will bring me to the Excel workbook. Is this possible?
> > How do I go about doing it? Thanks.
>
> Try adding an action setting, Hyperlink to:, Other file and pick your XLS file.
>
> When you click on the link during a slide show, PPT will launch the XLS file.
>
> Depending on version and your settings, it may insist on displaying a warning
> message about viruses and stuff before it lets you launch the XLS file.
>
> There's a fix for that, at least on your own PC.
>
> "Some files can contain viruses ..." message when clicking a hyperlink
> http://www.pptfaq.com/FAQ00406.htm
>
> >
> > "Echo S" wrote:
> >
> > > What do you mean, the links don't work in slide show view? Are you trying to
> > > click the cells and open an Excel workbook during a presentation? If so,
> > > that's different than the kind of links Brian and John are describing.
> > >
> > > --
> > > Echo [MS PPT MVP] http://www.echosvoice.com
> > > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> > >
> > >
> > >
> > > "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> > > news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> > > >I did the above suggestions to link Excel worksheets to Powerpoint which
> > > > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> > > > view,
> > > > the links don't work. You say the Excel file must be saved for linking to
> > > > stick? What does this mean/how do I do that?
> > > >
> > > > "Brian Reilly, MVP" wrote:
> > > >
> > > >> Just keep in mind that the XL file must first be saved for linking to
> > > >> stick.
> > > >>
> > > >> AND, don't move your files or your links will break.
> > > >>
> > > >> Brian Reilly, MVP
> > > >>
> > > >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> > > >> wrote:
> > > >>
> > > >> >John:
> > > >> >
> > > >> >PERFECT!
> > > >> >Just what I was looking for!
> > > >> >Thank you!!!!!!
> > > >> >
> > > >> >SRS
> > > >> >
> > > >> >"John Fallon" wrote:
> > > >> >
> > > >> >> In Microsoft Excel, select the range of cells you want to link, and
> > > >> >> then
> > > >> >> click Copy.
> > > >> >> Switch to Microsoft PowerPoint, and then click the slide or notes page
> > > >> >> where
> > > >> >> you want to insert the linked copy of worksheet cells.
> > > >> >> On the Edit menu, click Paste Special.
> > > >> >> Click Paste link.
> > > >> >> Hope this helps!!!
> > > >> >> --
> > > >> >> John Fallon
> > > >> >> Instructional Technology Evangelist for PPT4Teachers.com
> > > >> >> Where Instruction and Technology meet for Teachers and the Classroom
> > > >> >> http://www.ppt4teachers.com
> > > >> >>
> > > >> >>
> > > >> >> "SRS" wrote:
> > > >> >>
> > > >> >> > I have a map of the USA in a PPT presentation and a text box placed
> > > >> >> > in each
> > > >> >> > state. Once a month, I receive an excel spreadsheet with sales data
> > > >> >> > for each
> > > >> >> > state. Is there a way to link the text boxes with the excel
> > > >> >> > spreadsheet so
> > > >> >> > the data will update automatically instead of me having to go into
> > > >> >> > each
> > > >> >> > state, each month, and update manually?
> > > >> >> >
> > > >> >> > Thank you!
> > > >>
> > >
> >
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
In article <1931704F-0920-4EA8-BEDE-962DF07CCEF8@microsoft.com>, Kal4000 wrote:
> Thanks. I did the same thing to 3 icons that I have, and one of them works
> great, opening the Excel workbook, while the other two give me a box that
> says "Cannot open the specified file". Do you know how to fix this problem?
Try editing the hyperlink and put quotes around the filename.
>
> "Steve Rindsberg" wrote:
>
> > In article <CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com>, Kal4000 wrote:
> > > Yes, I have icons that I want to be able to click on during my powerpoint
> > > presentation which will bring me to the Excel workbook. Is this possible?
> > > How do I go about doing it? Thanks.
> >
> > Try adding an action setting, Hyperlink to:, Other file and pick your XLS file.
> >
> > When you click on the link during a slide show, PPT will launch the XLS file.
> >
> > Depending on version and your settings, it may insist on displaying a warning
> > message about viruses and stuff before it lets you launch the XLS file.
> >
> > There's a fix for that, at least on your own PC.
> >
> > "Some files can contain viruses ..." message when clicking a hyperlink
> > http://www.pptfaq.com/FAQ00406.htm
> >
> > >
> > > "Echo S" wrote:
> > >
> > > > What do you mean, the links don't work in slide show view? Are you trying to
> > > > click the cells and open an Excel workbook during a presentation? If so,
> > > > that's different than the kind of links Brian and John are describing.
> > > >
> > > > --
> > > > Echo [MS PPT MVP] http://www.echosvoice.com
> > > > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> > > >
> > > >
> > > >
> > > > "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> > > > news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> > > > >I did the above suggestions to link Excel worksheets to Powerpoint which
> > > > > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> > > > > view,
> > > > > the links don't work. You say the Excel file must be saved for linking to
> > > > > stick? What does this mean/how do I do that?
> > > > >
> > > > > "Brian Reilly, MVP" wrote:
> > > > >
> > > > >> Just keep in mind that the XL file must first be saved for linking to
> > > > >> stick.
> > > > >>
> > > > >> AND, don't move your files or your links will break.
> > > > >>
> > > > >> Brian Reilly, MVP
> > > > >>
> > > > >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> > > > >> wrote:
> > > > >>
> > > > >> >John:
> > > > >> >
> > > > >> >PERFECT!
> > > > >> >Just what I was looking for!
> > > > >> >Thank you!!!!!!
> > > > >> >
> > > > >> >SRS
> > > > >> >
> > > > >> >"John Fallon" wrote:
> > > > >> >
> > > > >> >> In Microsoft Excel, select the range of cells you want to link, and
> > > > >> >> then
> > > > >> >> click Copy.
> > > > >> >> Switch to Microsoft PowerPoint, and then click the slide or notes page
> > > > >> >> where
> > > > >> >> you want to insert the linked copy of worksheet cells.
> > > > >> >> On the Edit menu, click Paste Special.
> > > > >> >> Click Paste link.
> > > > >> >> Hope this helps!!!
> > > > >> >> --
> > > > >> >> John Fallon
> > > > >> >> Instructional Technology Evangelist for PPT4Teachers.com
> > > > >> >> Where Instruction and Technology meet for Teachers and the Classroom
> > > > >> >> http://www.ppt4teachers.com
> > > > >> >>
> > > > >> >>
> > > > >> >> "SRS" wrote:
> > > > >> >>
> > > > >> >> > I have a map of the USA in a PPT presentation and a text box placed
> > > > >> >> > in each
> > > > >> >> > state. Once a month, I receive an excel spreadsheet with sales data
> > > > >> >> > for each
> > > > >> >> > state. Is there a way to link the text boxes with the excel
> > > > >> >> > spreadsheet so
> > > > >> >> > the data will update automatically instead of me having to go into
> > > > >> >> > each
> > > > >> >> > state, each month, and update manually?
> > > > >> >> >
> > > > >> >> > Thank you!
> > > > >>
> > > >
> > >
> >
> > -----------------------------------------
> > Steve Rindsberg, PPT MVP
> > PPT FAQ: www.pptfaq.com
> > PPTools: www.pptools.com
> > ================================================
> >
> >
> >
>
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Thanks. My links work now! I right clicked on the icon, went to Action
Settings, and instead of clicking the bullet for "Hyperlink to:", I clicked
the bullet "Object Action:" and put it on Edit in the drop-down menu.
"Steve Rindsberg" wrote:
> In article <1931704F-0920-4EA8-BEDE-962DF07CCEF8@microsoft.com>, Kal4000 wrote:
> > Thanks. I did the same thing to 3 icons that I have, and one of them works
> > great, opening the Excel workbook, while the other two give me a box that
> > says "Cannot open the specified file". Do you know how to fix this problem?
>
> Try editing the hyperlink and put quotes around the filename.
>
> >
> > "Steve Rindsberg" wrote:
> >
> > > In article <CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com>, Kal4000 wrote:
> > > > Yes, I have icons that I want to be able to click on during my powerpoint
> > > > presentation which will bring me to the Excel workbook. Is this possible?
> > > > How do I go about doing it? Thanks.
> > >
> > > Try adding an action setting, Hyperlink to:, Other file and pick your XLS file.
> > >
> > > When you click on the link during a slide show, PPT will launch the XLS file.
> > >
> > > Depending on version and your settings, it may insist on displaying a warning
> > > message about viruses and stuff before it lets you launch the XLS file.
> > >
> > > There's a fix for that, at least on your own PC.
> > >
> > > "Some files can contain viruses ..." message when clicking a hyperlink
> > > http://www.pptfaq.com/FAQ00406.htm
> > >
> > > >
> > > > "Echo S" wrote:
> > > >
> > > > > What do you mean, the links don't work in slide show view? Are you trying to
> > > > > click the cells and open an Excel workbook during a presentation? If so,
> > > > > that's different than the kind of links Brian and John are describing.
> > > > >
> > > > > --
> > > > > Echo [MS PPT MVP] http://www.echosvoice.com
> > > > > What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> > > > >
> > > > >
> > > > >
> > > > > "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> > > > > news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> > > > > >I did the above suggestions to link Excel worksheets to Powerpoint which
> > > > > > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> > > > > > view,
> > > > > > the links don't work. You say the Excel file must be saved for linking to
> > > > > > stick? What does this mean/how do I do that?
> > > > > >
> > > > > > "Brian Reilly, MVP" wrote:
> > > > > >
> > > > > >> Just keep in mind that the XL file must first be saved for linking to
> > > > > >> stick.
> > > > > >>
> > > > > >> AND, don't move your files or your links will break.
> > > > > >>
> > > > > >> Brian Reilly, MVP
> > > > > >>
> > > > > >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> > > > > >> wrote:
> > > > > >>
> > > > > >> >John:
> > > > > >> >
> > > > > >> >PERFECT!
> > > > > >> >Just what I was looking for!
> > > > > >> >Thank you!!!!!!
> > > > > >> >
> > > > > >> >SRS
> > > > > >> >
> > > > > >> >"John Fallon" wrote:
> > > > > >> >
> > > > > >> >> In Microsoft Excel, select the range of cells you want to link, and
> > > > > >> >> then
> > > > > >> >> click Copy.
> > > > > >> >> Switch to Microsoft PowerPoint, and then click the slide or notes page
> > > > > >> >> where
> > > > > >> >> you want to insert the linked copy of worksheet cells.
> > > > > >> >> On the Edit menu, click Paste Special.
> > > > > >> >> Click Paste link.
> > > > > >> >> Hope this helps!!!
> > > > > >> >> --
> > > > > >> >> John Fallon
> > > > > >> >> Instructional Technology Evangelist for PPT4Teachers.com
> > > > > >> >> Where Instruction and Technology meet for Teachers and the Classroom
> > > > > >> >> http://www.ppt4teachers.com
> > > > > >> >>
> > > > > >> >>
> > > > > >> >> "SRS" wrote:
> > > > > >> >>
> > > > > >> >> > I have a map of the USA in a PPT presentation and a text box placed
> > > > > >> >> > in each
> > > > > >> >> > state. Once a month, I receive an excel spreadsheet with sales data
> > > > > >> >> > for each
> > > > > >> >> > state. Is there a way to link the text boxes with the excel
> > > > > >> >> > spreadsheet so
> > > > > >> >> > the data will update automatically instead of me having to go into
> > > > > >> >> > each
> > > > > >> >> > state, each month, and update manually?
> > > > > >> >> >
> > > > > >> >> > Thank you!
> > > > > >>
> > > > >
> > > >
> > >
> > > -----------------------------------------
> > > Steve Rindsberg, PPT MVP
> > > PPT FAQ: www.pptfaq.com
> > > PPTools: www.pptools.com
> > > ================================================
> > >
> > >
> > >
> >
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Right-click the icon, choose Action Settings.
On the Mouse Click tab, click Hyperlink To and choose Other File from the
dropdown list.
Navigate to your Excel file and choose it.
Run the presentation in slide show view to test the links.
--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
"kal4000" <kal4000@discussions.microsoft.com> wrote in message
news:CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com...
> Yes, I have icons that I want to be able to click on during my powerpoint
> presentation which will bring me to the Excel workbook. Is this possible?
> How do I go about doing it? Thanks.
>
> "Echo S" wrote:
>
>> What do you mean, the links don't work in slide show view? Are you trying
>> to
>> click the cells and open an Excel workbook during a presentation? If so,
>> that's different than the kind of links Brian and John are describing.
>>
>> --
>> Echo [MS PPT MVP] http://www.echosvoice.com
>> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>>
>>
>>
>> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
>> news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
>> >I did the above suggestions to link Excel worksheets to Powerpoint which
>> > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
>> > view,
>> > the links don't work. You say the Excel file must be saved for linking
>> > to
>> > stick? What does this mean/how do I do that?
>> >
>> > "Brian Reilly, MVP" wrote:
>> >
>> >> Just keep in mind that the XL file must first be saved for linking to
>> >> stick.
>> >>
>> >> AND, don't move your files or your links will break.
>> >>
>> >> Brian Reilly, MVP
>> >>
>> >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >John:
>> >> >
>> >> >PERFECT!
>> >> >Just what I was looking for!
>> >> >Thank you!!!!!!
>> >> >
>> >> >SRS
>> >> >
>> >> >"John Fallon" wrote:
>> >> >
>> >> >> In Microsoft Excel, select the range of cells you want to link, and
>> >> >> then
>> >> >> click Copy.
>> >> >> Switch to Microsoft PowerPoint, and then click the slide or notes
>> >> >> page
>> >> >> where
>> >> >> you want to insert the linked copy of worksheet cells.
>> >> >> On the Edit menu, click Paste Special.
>> >> >> Click Paste link.
>> >> >> Hope this helps!!!
>> >> >> --
>> >> >> John Fallon
>> >> >> Instructional Technology Evangelist for PPT4Teachers.com
>> >> >> Where Instruction and Technology meet for Teachers and the
>> >> >> Classroom
>> >> >> http://www.ppt4teachers.com
>> >> >>
>> >> >>
>> >> >> "SRS" wrote:
>> >> >>
>> >> >> > I have a map of the USA in a PPT presentation and a text box
>> >> >> > placed
>> >> >> > in each
>> >> >> > state. Once a month, I receive an excel spreadsheet with sales
>> >> >> > data
>> >> >> > for each
>> >> >> > state. Is there a way to link the text boxes with the excel
>> >> >> > spreadsheet so
>> >> >> > the data will update automatically instead of me having to go
>> >> >> > into
>> >> >> > each
>> >> >> > state, each month, and update manually?
>> >> >> >
>> >> >> > Thank you!
>> >>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Yes - got that thanks. Do you know why two of my three icons won't work in
my powerpoint presentation? I get a "Cannot open specified files" box instead
when I click on them. The other icon works perfectly.
"Echo S" wrote:
> Right-click the icon, choose Action Settings.
>
> On the Mouse Click tab, click Hyperlink To and choose Other File from the
> dropdown list.
>
> Navigate to your Excel file and choose it.
>
> Run the presentation in slide show view to test the links.
>
> --
> Echo [MS PPT MVP] http://www.echosvoice.com
> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>
>
>
> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> news:CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com...
> > Yes, I have icons that I want to be able to click on during my powerpoint
> > presentation which will bring me to the Excel workbook. Is this possible?
> > How do I go about doing it? Thanks.
> >
> > "Echo S" wrote:
> >
> >> What do you mean, the links don't work in slide show view? Are you trying
> >> to
> >> click the cells and open an Excel workbook during a presentation? If so,
> >> that's different than the kind of links Brian and John are describing.
> >>
> >> --
> >> Echo [MS PPT MVP] http://www.echosvoice.com
> >> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> >>
> >>
> >>
> >> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> >> news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> >> >I did the above suggestions to link Excel worksheets to Powerpoint which
> >> > works when I'm in Normal view in Ppt. However, when I'm in Slideshow
> >> > view,
> >> > the links don't work. You say the Excel file must be saved for linking
> >> > to
> >> > stick? What does this mean/how do I do that?
> >> >
> >> > "Brian Reilly, MVP" wrote:
> >> >
> >> >> Just keep in mind that the XL file must first be saved for linking to
> >> >> stick.
> >> >>
> >> >> AND, don't move your files or your links will break.
> >> >>
> >> >> Brian Reilly, MVP
> >> >>
> >> >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS <SRS@discussions.microsoft.com>
> >> >> wrote:
> >> >>
> >> >> >John:
> >> >> >
> >> >> >PERFECT!
> >> >> >Just what I was looking for!
> >> >> >Thank you!!!!!!
> >> >> >
> >> >> >SRS
> >> >> >
> >> >> >"John Fallon" wrote:
> >> >> >
> >> >> >> In Microsoft Excel, select the range of cells you want to link, and
> >> >> >> then
> >> >> >> click Copy.
> >> >> >> Switch to Microsoft PowerPoint, and then click the slide or notes
> >> >> >> page
> >> >> >> where
> >> >> >> you want to insert the linked copy of worksheet cells.
> >> >> >> On the Edit menu, click Paste Special.
> >> >> >> Click Paste link.
> >> >> >> Hope this helps!!!
> >> >> >> --
> >> >> >> John Fallon
> >> >> >> Instructional Technology Evangelist for PPT4Teachers.com
> >> >> >> Where Instruction and Technology meet for Teachers and the
> >> >> >> Classroom
> >> >> >> http://www.ppt4teachers.com
> >> >> >>
> >> >> >>
> >> >> >> "SRS" wrote:
> >> >> >>
> >> >> >> > I have a map of the USA in a PPT presentation and a text box
> >> >> >> > placed
> >> >> >> > in each
> >> >> >> > state. Once a month, I receive an excel spreadsheet with sales
> >> >> >> > data
> >> >> >> > for each
> >> >> >> > state. Is there a way to link the text boxes with the excel
> >> >> >> > spreadsheet so
> >> >> >> > the data will update automatically instead of me having to go
> >> >> >> > into
> >> >> >> > each
> >> >> >> > state, each month, and update manually?
> >> >> >> >
> >> >> >> > Thank you!
> >> >>
> >>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Sorry, I don't know. (Apologies for my late post, too. My signature block is
making posting spotty.)
Anyway, only thing I can think of is spaces in the file name. I think
Steve's suggestion to add quotation marks around the file name is a good
thing to try. Either that, or rename the files, as I suppose it could also
be an issue of path length, and a really long file name could contribute to
that.
--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
"kal4000" <kal4000@discussions.microsoft.com> wrote in message
news:2E54E587-F981-4C26-B491-BBD58F25DD03@microsoft.com...
> Yes - got that thanks. Do you know why two of my three icons won't work
> in
> my powerpoint presentation? I get a "Cannot open specified files" box
> instead
> when I click on them. The other icon works perfectly.
>
> "Echo S" wrote:
>
>> Right-click the icon, choose Action Settings.
>>
>> On the Mouse Click tab, click Hyperlink To and choose Other File from the
>> dropdown list.
>>
>> Navigate to your Excel file and choose it.
>>
>> Run the presentation in slide show view to test the links.
>>
>> --
>> Echo [MS PPT MVP] http://www.echosvoice.com
>> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>>
>>
>>
>> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
>> news:CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com...
>> > Yes, I have icons that I want to be able to click on during my
>> > powerpoint
>> > presentation which will bring me to the Excel workbook. Is this
>> > possible?
>> > How do I go about doing it? Thanks.
>> >
>> > "Echo S" wrote:
>> >
>> >> What do you mean, the links don't work in slide show view? Are you
>> >> trying
>> >> to
>> >> click the cells and open an Excel workbook during a presentation? If
>> >> so,
>> >> that's different than the kind of links Brian and John are describing.
>> >>
>> >> --
>> >> Echo [MS PPT MVP] http://www.echosvoice.com
>> >> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>> >>
>> >>
>> >>
>> >> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
>> >> news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
>> >> >I did the above suggestions to link Excel worksheets to Powerpoint
>> >> >which
>> >> > works when I'm in Normal view in Ppt. However, when I'm in
>> >> > Slideshow
>> >> > view,
>> >> > the links don't work. You say the Excel file must be saved for
>> >> > linking
>> >> > to
>> >> > stick? What does this mean/how do I do that?
>> >> >
>> >> > "Brian Reilly, MVP" wrote:
>> >> >
>> >> >> Just keep in mind that the XL file must first be saved for linking
>> >> >> to
>> >> >> stick.
>> >> >>
>> >> >> AND, don't move your files or your links will break.
>> >> >>
>> >> >> Brian Reilly, MVP
>> >> >>
>> >> >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS
>> >> >> <SRS@discussions.microsoft.com>
>> >> >> wrote:
>> >> >>
>> >> >> >John:
>> >> >> >
>> >> >> >PERFECT!
>> >> >> >Just what I was looking for!
>> >> >> >Thank you!!!!!!
>> >> >> >
>> >> >> >SRS
>> >> >> >
>> >> >> >"John Fallon" wrote:
>> >> >> >
>> >> >> >> In Microsoft Excel, select the range of cells you want to link,
>> >> >> >> and
>> >> >> >> then
>> >> >> >> click Copy.
>> >> >> >> Switch to Microsoft PowerPoint, and then click the slide or
>> >> >> >> notes
>> >> >> >> page
>> >> >> >> where
>> >> >> >> you want to insert the linked copy of worksheet cells.
>> >> >> >> On the Edit menu, click Paste Special.
>> >> >> >> Click Paste link.
>> >> >> >> Hope this helps!!!
>> >> >> >> --
>> >> >> >> John Fallon
>> >> >> >> Instructional Technology Evangelist for PPT4Teachers.com
>> >> >> >> Where Instruction and Technology meet for Teachers and the
>> >> >> >> Classroom
>> >> >> >> http://www.ppt4teachers.com
>> >> >> >>
>> >> >> >>
>> >> >> >> "SRS" wrote:
>> >> >> >>
>> >> >> >> > I have a map of the USA in a PPT presentation and a text box
>> >> >> >> > placed
>> >> >> >> > in each
>> >> >> >> > state. Once a month, I receive an excel spreadsheet with
>> >> >> >> > sales
>> >> >> >> > data
>> >> >> >> > for each
>> >> >> >> > state. Is there a way to link the text boxes with the excel
>> >> >> >> > spreadsheet so
>> >> >> >> > the data will update automatically instead of me having to go
>> >> >> >> > into
>> >> >> >> > each
>> >> >> >> > state, each month, and update manually?
>> >> >> >> >
>> >> >> >> > Thank you!
>> >> >>
>> >>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Thanks for all your help. I think I have them working now.
"Echo S" wrote:
> Sorry, I don't know. (Apologies for my late post, too. My signature block is
> making posting spotty.)
>
> Anyway, only thing I can think of is spaces in the file name. I think
> Steve's suggestion to add quotation marks around the file name is a good
> thing to try. Either that, or rename the files, as I suppose it could also
> be an issue of path length, and a really long file name could contribute to
> that.
>
> --
> Echo [MS PPT MVP] http://www.echosvoice.com
> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
>
>
>
> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> news:2E54E587-F981-4C26-B491-BBD58F25DD03@microsoft.com...
> > Yes - got that thanks. Do you know why two of my three icons won't work
> > in
> > my powerpoint presentation? I get a "Cannot open specified files" box
> > instead
> > when I click on them. The other icon works perfectly.
> >
> > "Echo S" wrote:
> >
> >> Right-click the icon, choose Action Settings.
> >>
> >> On the Mouse Click tab, click Hyperlink To and choose Other File from the
> >> dropdown list.
> >>
> >> Navigate to your Excel file and choose it.
> >>
> >> Run the presentation in slide show view to test the links.
> >>
> >> --
> >> Echo [MS PPT MVP] http://www.echosvoice.com
> >> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> >>
> >>
> >>
> >> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> >> news:CCEF0863-BD6B-44AE-A6C1-C113CBA6B8BB@microsoft.com...
> >> > Yes, I have icons that I want to be able to click on during my
> >> > powerpoint
> >> > presentation which will bring me to the Excel workbook. Is this
> >> > possible?
> >> > How do I go about doing it? Thanks.
> >> >
> >> > "Echo S" wrote:
> >> >
> >> >> What do you mean, the links don't work in slide show view? Are you
> >> >> trying
> >> >> to
> >> >> click the cells and open an Excel workbook during a presentation? If
> >> >> so,
> >> >> that's different than the kind of links Brian and John are describing.
> >> >>
> >> >> --
> >> >> Echo [MS PPT MVP] http://www.echosvoice.com
> >> >> What's new in PPT 2007? http://www.echosvoice.com/2007.htm
> >> >>
> >> >>
> >> >>
> >> >> "kal4000" <kal4000@discussions.microsoft.com> wrote in message
> >> >> news:71E54554-C503-436E-8062-2C642D1E552D@microsoft.com...
> >> >> >I did the above suggestions to link Excel worksheets to Powerpoint
> >> >> >which
> >> >> > works when I'm in Normal view in Ppt. However, when I'm in
> >> >> > Slideshow
> >> >> > view,
> >> >> > the links don't work. You say the Excel file must be saved for
> >> >> > linking
> >> >> > to
> >> >> > stick? What does this mean/how do I do that?
> >> >> >
> >> >> > "Brian Reilly, MVP" wrote:
> >> >> >
> >> >> >> Just keep in mind that the XL file must first be saved for linking
> >> >> >> to
> >> >> >> stick.
> >> >> >>
> >> >> >> AND, don't move your files or your links will break.
> >> >> >>
> >> >> >> Brian Reilly, MVP
> >> >> >>
> >> >> >> On Fri, 2 Dec 2005 12:38:01 -0800, SRS
> >> >> >> <SRS@discussions.microsoft.com>
> >> >> >> wrote:
> >> >> >>
> >> >> >> >John:
> >> >> >> >
> >> >> >> >PERFECT!
> >> >> >> >Just what I was looking for!
> >> >> >> >Thank you!!!!!!
> >> >> >> >
> >> >> >> >SRS
> >> >> >> >
> >> >> >> >"John Fallon" wrote:
> >> >> >> >
> >> >> >> >> In Microsoft Excel, select the range of cells you want to link,
> >> >> >> >> and
> >> >> >> >> then
> >> >> >> >> click Copy.
> >> >> >> >> Switch to Microsoft PowerPoint, and then click the slide or
> >> >> >> >> notes
> >> >> >> >> page
> >> >> >> >> where
> >> >> >> >> you want to insert the linked copy of worksheet cells.
> >> >> >> >> On the Edit menu, click Paste Special.
> >> >> >> >> Click Paste link.
> >> >> >> >> Hope this helps!!!
> >> >> >> >> --
> >> >> >> >> John Fallon
> >> >> >> >> Instructional Technology Evangelist for PPT4Teachers.com
> >> >> >> >> Where Instruction and Technology meet for Teachers and the
> >> >> >> >> Classroom
> >> >> >> >> http://www.ppt4teachers.com
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "SRS" wrote:
> >> >> >> >>
> >> >> >> >> > I have a map of the USA in a PPT presentation and a text box
> >> >> >> >> > placed
> >> >> >> >> > in each
> >> >> >> >> > state. Once a month, I receive an excel spreadsheet with
> >> >> >> >> > sales
> >> >> >> >> > data
> >> >> >> >> > for each
> >> >> >> >> > state. Is there a way to link the text boxes with the excel
> >> >> >> >> > spreadsheet so
> >> >> >> >> > the data will update automatically instead of me having to go
> >> >> >> >> > into
> >> >> >> >> > each
> >> >> >> >> > state, each month, and update manually?
> >> >> >> >> >
> >> >> >> >> > Thank you!
> >> >> >>
> >> >>
> >>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
Question
Answer
Notify me of replies