can I link an excel spreadsheet and do an auto update in Powerpoin

Steve,
I too am having the same issues. I have tried to follow this conversation
but it seems so muddled and confused. Can you simply reiterate what you have
told vm so I can follw what you have said.
My biggest issue is that I will have multiple charts to have in PP that will
link back to the master spreadsheet in excel. I want to have a seperate slide
for each line of data. There will be approximatly 45-60 slides. I want one
master spreadsheet to input my info into and have it automatically update in
each PP chart. Does that make sence? Is that possible?
Thank you so much!
--
Grandma always said the only dumb question was the one you didn''t ask!


"Steve Rindsberg" wrote:

In article , Wm wrote:
"Steve Rindsberg" wrote:

In article , Wm wrote:
"Steve Rindsberg" wrote:

In article , Wm wrote:
the link was helpful but didn't solve my problem. I have several graphs that
I need to show in Powerpoint but I create in Excel. I would like to have the
graph automatically update in Powerpoint when I update the data in Excel. Is
there a way to do that?

If the link didn't help, you'll need to be more specific about what you want.

The steps in the FAQ page will give you links that will update each time you open
the presentation. Do you need something other/more than that?


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Steve,

I didn't see where I could get the actual graph from Excel into the
Powerpoint presentation. I could get a data table that I could link and it
would update but what I need is the graph that is fed from Excel data to
automatically update.

Thanks for your persistence in helping me with this......WM

No problem. In Excel, you select whatever content you want to link to PPT.
If that's a chart on a chart sheet, click in the upper left corner and make sure that
you've got the Chart Area selected.
For a chart on a regular work sheet, again, click the upper left and make sure it's
the whole chart area that's selected.

In both cases, the tooltip (little yellow text box that appears over the mouse cursor)
will show you what's selected.

And in both cases, it doesn't really need to be the upper left that you click, but
click on the chart but away from everything else that's selectable. U/L makes it nice
and simple.



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Steve,

I already cut and paste my graphs from Excel to Powerpoint. What I can't
seem to find a way to do is to have the chart in Powerpoint automatically
linked so that it updates each time I change the data in Excel. When I cut
and paste I don't have the option of Paste Special and using the linking
function. Is there a way to have the Excel Spreadsheet in Powerpoint and
have it automatically linked so that the updates can happen?

Yes, by doing it exactly as described in the various links already given.

As mentioned, you can't cut and paste. You want to Copy from Excel and then choose Edit,
Paste Special in PPT.

You must have first saved the Excel file for this to work and you must initiate it from
Excel; you can't do it from within PPT.





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

In article , Lori C wrote:
Steve,
I too am having the same issues. I have tried to follow this conversation
but it seems so muddled and confused. Can you simply reiterate what you have
told vm so I can follw what you have said.
My biggest issue is that I will have multiple charts to have in PP that will
link back to the master spreadsheet in excel. I want to have a seperate slide
for each line of data. There will be approximatly 45-60 slides. I want one
master spreadsheet to input my info into and have it automatically update in
each PP chart. Does that make sence? Is that possible?
Thank you so much!

Looks like Gary beat me to it and you beat him to it. Nice work!


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Hi Steve or Lori, could you repeat the answer that Lori received? It doesn't
seem to be displayed anywhere. I would be really grateful, this is exactly
the question I have. thanks much.
ZL

"Steve Rindsberg" wrote:

In article , Lori C wrote:
Steve,
I too am having the same issues. I have tried to follow this conversation
but it seems so muddled and confused. Can you simply reiterate what you have
told vm so I can follw what you have said.
My biggest issue is that I will have multiple charts to have in PP that will
link back to the master spreadsheet in excel. I want to have a seperate slide
for each line of data. There will be approximatly 45-60 slides. I want one
master spreadsheet to input my info into and have it automatically update in
each PP chart. Does that make sence? Is that possible?
Thank you so much!

Looks like Gary beat me to it and you beat him to it. Nice work!


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

For what it's worth, I can't see the answer she received, either. The
archive seems to be incomplete.

http://groups.google.com/group/micro...4b10065360bd57

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"Zack L" wrote in message
...
Hi Steve or Lori, could you repeat the answer that Lori received? It
doesn't
seem to be displayed anywhere. I would be really grateful, this is
exactly
the question I have. thanks much.
ZL

"Steve Rindsberg" wrote:

In article , Lori C
wrote:
Steve,
I too am having the same issues. I have tried to follow this
conversation
but it seems so muddled and confused. Can you simply reiterate what you
have
told vm so I can follw what you have said.
My biggest issue is that I will have multiple charts to have in PP that
will
link back to the master spreadsheet in excel. I want to have a seperate
slide
for each line of data. There will be approximatly 45-60 slides. I want
one
master spreadsheet to input my info into and have it automatically
update in
each PP chart. Does that make sence? Is that possible?
Thank you so much!

Looks like Gary beat me to it and you beat him to it. Nice work!


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

People, I have had the exact same problem. No offense to the Micosoft Office
Experts, but it seems you guys are not catching what the users are asking.
I'm unsure if it is that the users do not know how to explain themselves
properly or maybe because you guys do not understand the situation or
frustration of the users.

I know what it feels like because I have experienced it first-hand this week
(13 July 2009 to 16 July 2009).

Between myself and my collegue, we have done extensive research on this
issue and have found a workable and quite friendly solution to the problem.

The problem is this; When you have a "Display" machine like a "Kiosk" in the
staff canteen. You would like to have a PowerPoint presentation running there
24/7. The problem is to update this presentation without touching the
"Dispaly" PC. PowerPoint does not allow a smooth update to the presentation
without user intervention. The Presentation should work FOR YOU, and YOU FOR
the presentation.

Guys, if you would like to know the solution, please, e-mail me on
, I will gladly help you to solve this problem!

"wm" wrote:

I have a daily/monthly financial and production report that has excel
spreadsheets that I am currently cutting and pasting from Excel into
Powerpoint. I would like to find a way to have the spreadsheet automatically
update in Powerpoint when I change it in Excel. Is this possible?

I know this is an old thread, but just wanted to say THANK YOU -- I came out
here to post about wanting to find a solution like this, and found this
thread which met my needs well. Thank you.

"wm" wrote:

I have a daily/monthly financial and production report that has excel
spreadsheets that I am currently cutting and pasting from Excel into
Powerpoint. I would like to find a way to have the spreadsheet automatically
update in Powerpoint when I change it in Excel. Is this possible?

Glad you found what you were looking for, Julie. Thanks for letting us know!

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx



"Julie C" wrote in message
...
I know this is an old thread, but just wanted to say THANK YOU -- I came
out
here to post about wanting to find a solution like this, and found this
thread which met my needs well. Thank you.

"wm" wrote:

I have a daily/monthly financial and production report that has excel
spreadsheets that I am currently cutting and pasting from Excel into
Powerpoint. I would like to find a way to have the spreadsheet
automatically
update in Powerpoint when I change it in Excel. Is this possible?