Link Excel data to Powerpoint ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!!!
 
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
 
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?
 
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.
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
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 said:
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.
Click to expand...

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 said:
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



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?

:

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

John:

PERFECT!
Just what I was looking for!
Thank you!!!!!!

SRS

:

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


:

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!
Click to expand...
Click to expand...

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Click to expand...
 
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 said:
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 said:
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 said:
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?

:

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

John:

PERFECT!
Just what I was looking for!
Thank you!!!!!!

SRS

:

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


:

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!
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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



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?

:

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

John:

PERFECT!
Just what I was looking for!
Thank you!!!!!!

SRS

:

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


:

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!
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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.

:

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



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?

:

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
<[email protected]>
wrote:

John:

PERFECT!
Just what I was looking for!
Thank you!!!!!!

SRS

:

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


:

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!
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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?
Click to expand...

Try editing the hyperlink and put quotes around the filename.
Steve Rindsberg said:
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


:

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



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?

:

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

John:

PERFECT!
Just what I was looking for!
Thank you!!!!!!

SRS

:

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


:

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
================================================
Click to expand...
Click to expand...

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Click to expand...
 
Thanks for all your help. I think I have them working now.

Echo S said:
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 said:
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 said:
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



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.

:

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



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?

:

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
<[email protected]>
wrote:

John:

PERFECT!
Just what I was looking for!
Thank you!!!!!!

SRS

:

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


:

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!
Click to expand...
Click to expand...
Click to expand...
 
John;

The data in my excel sheet will grow, with new data added each month to the
next row. For example, I have data in columns A & B and rows 1 - 20 (each
row represents a month of data). Next month I'll have data in rows 1 - 21,
and so forth. When I select a broad range of cells to use as my link (rows 1
- 100) the PowerPoint line graph includes a single blank month at the end of
the chart, as if it thinks there is data there.

Is there any way to prevent this blank from occuring? We do not want to
have to relink the PowerPoint graphs to a new Excel range each month.

Any help would be appreciated.
Thanks very much,
Rich
 
Back
Top