Linked Excel To Powerpoint

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

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.

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 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?

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

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.

Hello guys!

I have a cool, but annoying, glitch in Excel I wanted to share and see if any of you have come across it and have a simple way to fix it.

Background: I work for a company that pastes graphs from Excel to Powerpoint often. We recently have upgraded from Office 2007 to Office 2010, and in doing so, we've been saving files as .xlsx or .xlsm rather than .xls.

The Glitch: We had an intern working on updating graphs (simply selecting new data in place of old data for the same graph within the same file) and then paste it into Powerpoint. I was called over, because I know a great deal more of Excel knowledge than them, to look at a problem he was having...

The intern would copy a bar graph (let's name it "Graph A"), paste it as an Enhanced Metafile into Powerpoint, copy another bar graph (let's call this one "Graph B"), and attempt to paste it as another Enhanced Metafile in the same Powerpoint file, but Graph A would be pasted down instead of Graph B.

I attempted to see if I could reproduce this using other graphs. I copied other graphs (Graph C, D, E, and F) and then tried to copy and paste Graph B again, but only Graphs C, D, E, and F appeared.

I could not get Graph B to paste! And no other graph would do the same thing that Graph B was doing (not show up while pasting the previous copied graph.)

Question/Solution: I solved this problem by recreating the graph, but I am confused and interested in how this is happening and if there is a true solution. Has this ever happened to anyone else? Why are these past copied graphs coming back from the dead and not Graph B?

Hundreds of threads regarding powerpoint-excel linking out here, but nowhere have I seen the answer to my question.

I am creating presentations in Powerpoint with charts from a standardized excel file. The charts are linked. Each excel file contains data from one company.

But when I receive a NEW excel file/company, I would like to simply copy my powerpoint presentation template and update the links to this new excel file. Since there are maybe 50 charts linked I do not want to update each link separately.

Does anyone have a clue?

Oh, and I use simple copy-paste to create the presentation today - no vba programs.

Hi everybody, i usually makes presentations in Powerpoint by linking data from an Excel sheet and creating a chain, so i can alter in the Excel sheet and just update the Powerpoint.
After i changed to 2010, it seems that it is not working as before, i can keep source formatting and chain data, but it does not update, has anyone had the same problems? - and how do i remove the link/chain from a powerpoint presentation, in older versions, i could remove all the links in the chain menu