Hi, let me re-iterate your problem. You are trying to copy data from excel sheet and put it into a linked excel sheet in the PPT to create graphs right? This can be done in VBA using OLE objects but unfortunately we cannot do it in Excel 2007 as this feature has been taken off. Having said that you can definitely do this in earlier versions of Excel.
On 3/27/11, Deepak Pal Singh <deepaktheind...@gmail.com> wrote: > Hi Ashish, > > I'd attached the PPT in my last mail & you can find the charts source data > in the embedded excel file. You need to right click on the chart & then > click on edit option.. > > Thanks.. > > On Sun, Mar 27, 2011 at 11:21 AM, ashish koul <koul.ash...@gmail.com> wrote: > >> can you attach the source data as well >> >> >> On Sun, Mar 27, 2011 at 9:58 AM, Deepak Pal Singh < >> deepaktheind...@gmail.com> wrote: >> >>> Hi Guy's, >>> >>> I'm still waiting for your help... >>> >>> ---------- Forwarded message ---------- >>> From: Deepak Pal Singh <deepaktheind...@gmail.com> >>> Date: Sat, Mar 26, 2011 at 7:55 PM >>> Subject: $$Excel-Macros$$ Edit Data In Embedded Excel Charts Within >>> Powerpoint Using VBA >>> To: excel-macros@googlegroups.com >>> >>> >>> Hi Guy's, >>> >>> I need your help, I’ve a PPT with embedded an excel file. I want to show >>> the chart given on the sheet1 of the embedded workbook on my PPT. My >>> chart >>> has dynamic range whenever I change the month on from the cell “H1” on >>> the >>> sheet1 the source data gets changed according to the table given on the >>> same >>> sheet. Now I want the same functionality in PPT as well, I’ve tried and >>> write a code to do this, however I’m getting wrong somewhere, I’m not >>> able >>> to find what I’m missing..Getting an error message during compilation >>> “OLEFormat (unknown member): Invalid request. This property only applies >>> to OLE objects”, please go through my code and solve my problem. >>> >>> >>> >>> Thanks & Regards >>> >>> Deepak >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
