Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

Linked Excel To Powerpoint

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

All,

I have a task to do which i want to streamline, the basics are thus:

1. I have a main spreadsheet 'X' that has about 5 tabbed sheets within it, e.g A to E where A is the totals of B to E.

2. I have another spreadsheet 'Y' which manually takes the totals data from the A tab in 'X' and lists them in more decipherable order. Graphs which update from the data shown are already present in this sheet.

3. I have a legacy Powerpoint show which contains pasted data in the form of the graphs from 'Y'; graphs that at this time are represented simply as a picture and not data per se.

The current method of updating the flow is manual copying and pasting. What i want to know is that can i link the data from 'X' into 'Y' which in turn links into Powerpoint so that when anydata along the excel chain changes, it reflects in the linked charts within Powerpoint. The set up may be fairly time consuming, but i assume that if this is all possible, the running through each additional and updated sets of data would be much quicker.

I would love your more considered thoughts on this if possible as it would be a great help.

Thanks in advance.

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Open Microsoft PowerPoint from Excel
- This free macro will open the Microsoft PowerPoint program on your computer. You do need to have this program first. T
Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Display The Actual Link / Email Address From Links in Excel - UDF
- Display the actual link or email address from links within Excel with this UDF. This user defined function pulls the ac
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the

Similar Topics









Hi all,

I really need your help.

I have this data coming from a web survey that I paste into an excel sheet. This excel sheet then converts this data into graphs in another tab in the excel sheet.

These graphs are then linked to a Powerpoint - which is used to present the data in an appetizing way. But what I need to be able to do is to duplicate the excel sheet and powerpoint together when I want to use the set up for another web survey. Since there is always some changes to every report and powerpoint (like including just some of the data, or some of the graphs, or chaing the order they are shown in the ppt... ) - it is not optimal to use the same excel sheet every time.

So I need a standard set up excel sheet and ppt - that I can then in a simpel way duplicate when ever I am doing a new survey. How would I do this in the most simple way?

Also - is there any way I can link the graphs in excel to the powerpoint where they are linked in the way that if I change the data or graphs in the excel - it will be updated in the Powerpoint - but ALSO that I am able to design the graph in Powerpoint??? (and not excel)

so grateful for help!

Hi,

I have a Powerpoint file that has a number of relatively complicated graphs in it, I need to update these graphs to include the data for November. But this Powerpoint was created by a colleague who has now left the company and had the linked Excel sheets stored on his PC.

The graphs are embedded Excel graphs, but when I right click to edit data, it says that the linked Excel files are unavailable. The data is obviously stored within the Powerpoint sheet though as the graphs display correctly and there is no way they could be accessing his now deactivated network share.

How can I extract the current data, allowing me to update the graphs?

Any help would be greatly appreciated.

Thanks


Hi,

I have a Powerpoint file that has a number of relatively complicated graphs in it, I need to update these graphs to include the data for November. But this Powerpoint was created by a colleague who has now left the company and had the linked Excel sheets stored on his PC.

The graphs are embedded Excel graphs, but when I right click to edit data, it says that the linked Excel files are unavailable. The data is obviously stored within the Powerpoint sheet though as the graphs display correctly and there is no way they could be accessing his now deactivated network share.

How can I extract the current data, allowing me to update the graphs?

Any help would be greatly appreciated.

Thanks

Hi,

I have to compile a report once a month in excel then present the data in powerpoint.

The problem is the report has about 25 graphs in it.

The way I currently do it means I have to open powerpoint, then edit each graph one by one, powerpoint treats each graph as a separate spreadsheet and its a real pain to edit.

What I would like to have is 1 spreadsheet with all the graphs in already linked to the relevant data. All I want to do is edit some of the data in the spreadsheet then have all the graphs in the powerpoint file update accordingly.

How do I do this? I tried linking spreadsheets to powerpoint but had problems with multiple graphs.

Cheers


I'll buy a pint for anyone who can helpsave me an endless amount of time copying and pasting excel charts ito powerpoint...the problem is

(1) When I copy and paste charts into powerpoint I originally went through the paste special, paste link function. However when I right click on the chart in powerpoint and "update links" the chart/graph goes absolutely massive across the whole slide - I then have to click on the slide and delete it....hence at the moment I'm copying and pasting in as a picture each time (which is hard work every month when you are doing 30+ graphs)

All I want to be able to do is set them up in powerpoint and just update links everymonth !

I have a number of charts per slide (between 1 and 6) not sure if this impacts - but they have to be there as this is the report format

i Will buy a pint for anyone who can help me solve this one !!


(2) As an aside what is the best way to get graphs into powerpoint from a seperate excel workbook ? Even when i copy in as pictures i still have to resize each and everyone of them once in powerpoint, are there any shortcuts to this?

Manythanks


I'll buy a pint for anyone who can help save me an endless amount of time copying and pasting excel charts ito powerpoint...the problem is

(1) When I copy and paste charts into powerpoint I originally went through the paste special, paste link function. However when I right click on the chart in powerpoint and "update links" the chart/graph goes absolutely massive across the whole slide - I then have to click on the slide and delete it....hence at the moment I'm copying and pasting in as a picture each time (which is hard work every month when you are doing 30+ graphs)

All I want to be able to do is set them up in powerpoint and just update links everymonth !

I have a number of charts per slide (between 1 and 6) not sure if this impacts - but they have to be there as this is the report format

i Will buy a pint for anyone who can help me solve this one !!


(2) As an aside what is the best way to get graphs into powerpoint from a seperate excel workbook ? Even when i copy in as pictures i still have to resize each and everyone of them once in powerpoint, are there any shortcuts to this?

Manythanks


Hi,
I am using Excel 2007 & PowerPoint 2007.

I have a workbook which is pretty big (+10mb)

I am creating pivot tables based on a large data set in the spread sheet and then creating pivot charts to represent the data.

In order to present these charts I am using Power point and to automate picking up the graphs I have pasted the graphs as links into the PPT.

It all works the problem is the update process is really slow, when opening PowerPoint and updating the links it looks like it opens the spreadsheet updates a link , closes the spreadsheet, moves to the next link opens the sheet again and so on until all the links are updated.

If I open the spreadsheet before updating the spreadsheet then it locks up.

When creating the sheet initially the links update dynamically and really quickly, is there a way to speed this process up?

Tks

damib




Okay, I have been at it for a couple hours and I cannot seem to figure out my problem...

1. I have 12 charts which are copied and pasted from Excel to Powerpoint (bar graphs, pie, line charts)
2. I previously set it up to automatically update all of the links (i.e. paste special), thereby updating them as soon as you open the powerpoint.
3. I had to move the files and make some adjustments, so I repeated steps 1 and 2.
4. Now, for some reason only the line charts are not updating. The pie charts and bar graphs are updating, but not the line charts.

I cannot figure out what the issue is with the setup. I copied and pasted all of them the same way, but some of them just refuse to update.... ughhh

This is a different powerpoint presentation than what I previously used? Is there some issue with the line charts? Does powerpoint not accept certain chart types?

The following three functions are the dynamic ranges setup for a single chart:
OVERDUE =OFFSET('Metrics'!$D$33,0,COUNT(Datewksht)-13,1,13) - line A refers to row of data A
OPEN =OFFSET('Metrics'!$D$32,0,COUNT(Datewksht)-13,1,13) - line B refers to row of data B
Date =OFFSET('Totals'!$D$2,0,COUNTIF('Totals'!$D$2:$BQ$2,"<>#N/A")-13,1,13) - y-axis
Datewksht ='Totals'!$D$2:$BQ$2 - this is a row of dates, every 7 days

FYI
-Office 2010
-The old way used a different powerpoint presentation template
-All line charts update accordingly within excel
-updated dynamic ranges with most current revision



Please help!

Hi,
Im still learning the ways of VBA. I have now created a number of graphs in excel which I would like to have updated to a PowerPoint presentation when I excute a program (graphs will be updated weekly). I tried recording a macro from PowerPoint which would tell me how the update link feature works, but it only showed the selection of the graph I wanted to update nothing more.

What the I really want to do is have all the graphs in the PowerPoint updated with the click of a single program. Is this even possible?

I tried searching previous discussions on the topic and saw that Tusharm has been active, but still havent found a solution.

Any ideas?

Thanks!


All,

I have spent quite a bit of time creating graphs in excel from worksheet data and then pasting the graph as a linked object into Powerpoint so future editing is easy. However the pie graphs that print out in Powerpoint are jagged and not good enough to print. Can anyone tell me how to resolve this? I am using Powerpoint 2003 on Windows XP SP2

Cheers.


I am currently using Office 2007. I am linking charts from my Excel model to Powerpoint. Whenever I do this, my Powerpoint freezes. I have yet to find a way to link my graphs to Powerpoint. I hate copying these graphs via copy paste, enhanced metafiles in Powerpoint because it's become so redundant. This is why I created a model to automate things. Any reason why this is happening?


A presentation created and maintained by someone else was recently dropped on my plate. It contained a series of graphs created in Powerpoint and data was just manually added in each sheet from another sheet.

It contained, for the most part, 2 graphs per slide and they presented well as they were created in Powerpoint. I created some dynamic graphs in Excel from the original data sheet, with dynamic ranges, but realized that I cannot get the presentation to look remotely readable if i try to have 2 graphs were slide this way. Everything bunches up and it looks a mess.

Is there a way around this? I didn't know if I could maybe have blank powerpoint graphs (templates i suppose) and vba that brought in the appropriate data into the graphs to make them dynamic.


Hi forum,

I'm using XL and PowerPoint 2007. I've been able to create charts in PowerPoint that are linked to a specific XL file that has all of the data for multiple PowerPoint charts.

My goal is to have this XL file as the only companion file a user needs to update so that any changes he/she makes here will automatically propagate to the PowerPoint file.

Unfortunately, my issue is that when I email the PowerPoint and XL documents together, the PowerPoint file will retain the link to the XL file in my specific hard drive and so, a new user has to go edit the links manually to point to the new XL file. I would rather the PowerPoint file not care where the XL was originally saved and instead, only look for the XL file in the same directory as the PowerPoint file.

Is there an easy way for this to be done automatically? Can this be done in VBA?

Thanks for any thoughts!


Hi,

I have been given the task of writing a macro to load data from multiple excel worksheets into a powerpoint presentation to construct graphs.

I have seen lots of info about copying and pasting the graphs from excel into powerpoint but I want to construct them with powerpoint.

Is this possible?


Hello gang,

I am fairly confident with Excel have created a number of graphs that have drop down boxes to choose which data is charted. i have been asked if this can be done in powerpoint (at the moment we take 'snapshot' copies and paste them into Powerpoint but would like to have the similar functionality as the Excel document).

Is there a way of linking?

I know that you can put a shortcut to the spreadsheet into Powerpoint but that is worst case solution.

Thank you in advance for any assistance you can offer.




Hello everybody,

I have a workbook_open event that automatically refreshes two data tables when the user opens the Excel document. The data it refreshes is fed into several graphs. The graphs are then linked to PowerPoint.

The problem I am encountering is that when I open the PowerPoint document to update the graphs, it automatically runs the Excel macro as well. I have six graphs, so it definitely increases the updating time when I have to wait for it to refresh the two tables six times each.

Does anybody know the code I can add to the beginning of the workbook_open event to prevent the rest of the code from running if the Excel document is opened through PowerPoint?

Thanks!

I have a report that shows sale figures for the company against various indicators. I create this report thru creating graphs directly in Powerpoint. The underlying data however comes from calculations from an Excel File.

I would like to eliminate the need to copying the numbers from Excel and pasting them in to Powerpoint graphs. I plan on just creating graphs in Excel and sending out as a PDF when completed.

The problem is that my company uses these Powerpoint Templates that have the Header bar at the top and a footer bar at the bottom. These are just a yellow bar with small pictures in them. Also, the template has a fancy Title Page.

I would like to extract these headers and footers from out PowerPoint template, paste them within an Excel sheet and set the page breaks. The graphs will go below the header. and when I save/send as PDF, it will look very similar to the first method.

Thanks,
cappa


I am copying and pasting objects/charts from Excel into Powerpoint as linked objects, so that these can be updated in Powerpoint automatically. However, I am running into minor formatiing issues.

So I copy and paste in to Powerpoint, all is good. Then when I update the link, the size and format of the file goes a little crazy. Depending on the chart, it will shrink or grow. But I can live with the sizes changing, as I can always make a macros to fit, however, after updating, the gridlines go all thin and skinny. Is there any way to fix that? I have already tried to use bold or thicker gridlines on the linked excel spreadsheet, however, this does not seem to solve the problem. Any help would be apprecited.


Quick question - is it possible for PowerPoint to hold graphs that are lifelinked to Excel? i.e. either the graph is held in the Excel file and linked to the PowerPoint file or PowerPoint has the chart itself and it is formed by external data held in the Excel file.


Hello All,

I am in need of assistance and hope some one may have done this ...

I want to embed a PowerPoint file inside Excel. No problem, I know how to do that. In the PowerPoint, I have created some links to the excel charts, graphs, tables etc. so that when some one updates input variables in Excel, the charts, etc. will change and automatically update the linked object in PowerPoint.

Here is where I have a problem. The linked objects in PowerPoint point back to the Excel source file with a specific name. I want to create a master Excel so that users can copy the master and have a new Excel file. Then they would update the new Excel file which would update charts, etc. which are linked in PowerPoint. The problem is that once the Excel file is copied with a new name, the link pointer in the embedded PowerPoint still point back to the original source file. I want to dynamically change the linked pointers in PowerPoint to point to the new (currently being modified) file.

Is this possible? Can some one provide assistance ... maybe some VBA code examples.

Thanks,

Steve B.


We have a zillion charts/data linked into several wonderful PowerPoint presentations so as the data changes, the presentation is updated. One problem: When the data changes, some of our linked Excel data MOVES on the page in PowerPoint. And not nicely! I realize that this is not exactly an Excel question, but does anyone know how to avoid this moving, to anchor the link to a spot in PowerPoint, or something akin to that? THANKS


Hi,
I have a PowerPoint Presentation that has about 100 links to charts and graphs in about 6 different Excel workbooks that needs to be updated each month to link to a new set of Excel workbooks; therefore, I created a search and replace macro in Powerpoint to update all of the links simultaneously; however it causes the "Do You Want to Update Links" Alert to come up for every single linked object. I saw that you can disable the alert in Excel, but since there are multiple users I would have to go back in and turn them on after running the macro. Is there a way to suppress this alert when running the macro?

Thanks,
g


Hi Guys

Can excel graphs be updated on powerpoint real-time?

If i have a table and graph that i copied from excel and pasted to powerpoint, everytime that i update the table on powerpoint can it also adjust the graph accordingly?

And if it is possible how do i do this?


I have a powerpoint presentation with ~80 charts that link to data on excel worksheets. I created the links by copying the cells in excel and by opening the chart datasheet in Powerpoint and entering Edit / Paste link. The links are set to automatically update - but they don't - I have to click on each one of them and open the datasheet for them to update.

From what I've read on Microsoft Help the links should be updating. I'm I missing something? I know this is more of a Powerpoint question - but any help would be appreciated - too much clicking!


I'm not sure if this is the correct forum to post this in, but this is best place I could find.

I am pasting graphs from excel into powerpoint slides and the graphs keep updating whenever I change my information to do the next slide. This is a problem for me, as I dont want them updating since they are updating with incorrect information. After a long google search, I found the problem was that the table was linking to Excel.

My current solution to this is everytime I paste in a table, I go to Start>Prepare>Edit Links to Files>Break Link. This is an annoying process and I want to know if there is a setting in Powerpoint or Excel that stops these from linking. I have 40 of these to do.