 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / June 2006Linking from excel to PPT
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!  SignatureGrandma always said the only dumb question was the one you didn't ask! Lori, This should work. Copy each chart and paste into PPT where you'd like it. However, don't just click paste - click Edit-Paste Special and choose Paste Link. Now when you change your spreadsheet data, the next time you open PPT it will prompt to refresh from linke files. Also, be sure not to move or rename the files as that would most likely break the links. hth > 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! Gary, While waiting for you to come to my rescue I was playing around and I did it! Yahoo! Thank you so much for replying to my post! It helps to validate what I figured out and it's nice to kow this posting stuff works! SignatureGrandma always said the only dumb question was the one you didn't ask! > Lori, > [quoted text clipped - 17 lines] > > each PP chart. Does that make sence? Is that possible? > > Thank you so much! Your welcome, Lori. > Gary, > [quoted text clipped - 23 lines] > > > each PP chart. Does that make sence? Is that possible? > > > Thank you so much! this is great. but when i edit it, even a simple open and close, it reformats in ppt, extends the height, gridlines come on, and looks like a completely diff excel file... any way to stop this? > Your welcome, Lori. > [quoted text clipped - 25 lines] > > > > each PP chart. Does that make sence? Is that possible? > > > > Thank you so much! I just responded to your previous post. SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/ PPTLive! Sept 17-20, 2006 http://www.pptlive.com > this is great. but when i edit it, even a simple open and close, it > reformats [quoted text clipped - 40 lines] >> > > > each PP chart. Does that make sence? Is that possible? >> > > > Thank you so much! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.