If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Powerpoin
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? |
#2
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Powerpoin
Hi, check this out and see if it helps:
"Linking information from Excel" http://www.rdpslides.com/pptfaq/FAQ00593.htm -- Site Updated: December 04, 2005 http://www.pptheaven.xs3.com PowerPoint Heaven - The Power to Animate Contains tutorials on creating amazing animations for your PowerPoint Presentations. ========= "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? |
#3
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Powerpoin
In article , 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? You bet. Linking information from Excel http://www.rdpslides.com/pptfaq/FAQ00593.htm ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
#4
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Powerpoin
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? "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? |
#5
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Powerpoin
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 ================================================ |
#6
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Power
"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 |
#7
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Power
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 ================================================ |
#8
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Power
"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? WM |
#9
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Power
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 ================================================ |
#10
|
|||
|
|||
can I link an excel spreadsheet and do an auto update in Power
Steve,
I finally got it!! For some reason when I tried this the first time I couldn't find the Paste Special. Thanks for your persistent help. I really appreciate it!! "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 ================================================ |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
How to link a word field to an excel spreadsheet | Matt | General Discussion | 1 | January 26th, 2005 07:37 PM |
Clicking an Excel spreadsheet opens Excel, but then it stops in Re | fredchu | Setup, Installing & Configuration | 1 | September 17th, 2004 12:41 PM |
auto format 5 worksheets out of 6 when opening excel spreadsheet. | mike | Worksheet Functions | 1 | December 26th, 2003 08:37 PM |
Add-In Link from Excel to Access | Ann Mindy | Worksheet Functions | 0 | November 16th, 2003 04:08 PM |