 |
 | 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 / September 2006How can I import data from various spreadsheets to Powerpoint?
I have Powerpoint slides that use information residing in various Excel spreadsheets on the same shared drive. How can I link the data from the speadsheets to the slides so I don't have to manually enter the data each time? Thanks in advance for your help. If you insert the excel files as objects > browse from file and tick "link" every time you open powerpoint it will ask if you want to update  SignatureDid that answer the question / help? _____________________________ John Wilson Microsoft Certified Office Specialist http://www.technologytrish.co.uk/ppttipshome.html > I have Powerpoint slides that use information residing in various Excel > spreadsheets on the same shared drive. How can I link the data from the > speadsheets to the slides so I don't have to manually enter the data each > time? Thanks in advance for your help. I'm not importing all the data on the spreadsheets, just date from certain cells. I need to be able to create several powerpoint slides that contain the same data as resides in these particular cells in Excel. > I have Powerpoint slides that use information residing in various Excel > spreadsheets on the same shared drive. How can I link the data from the > speadsheets to the slides so I don't have to manually enter the data each > time? Thanks in advance for your help. Jan I've never used this but it looks like what you need http://www.rdpslides.com/pptools/merge/index.html SignatureDid that answer the question / help? _____________________________ John Wilson Microsoft Certified Office Specialist http://www.technologytrish.co.uk/ppttipshome.html > I'm not importing all the data on the spreadsheets, just date from certain > cells. I need to be able to create several powerpoint slides that contain the [quoted text clipped - 4 lines] > > speadsheets to the slides so I don't have to manually enter the data each > > time? Thanks in advance for your help. This certainly looks like it would work. Unfortunately, I'd have to purchase the software and that's not an option. What if I created another spreadsheet in Excel and linked all the data to it, then imported that spreadsheet into PowerPoint? I think I'll try that, but thanks anyway for your efforts. > I'm not importing all the data on the spreadsheets, just date from certain > cells. I need to be able to create several powerpoint slides that contain the [quoted text clipped - 4 lines] > > speadsheets to the slides so I don't have to manually enter the data each > > time? Thanks in advance for your help. Type the info you want into a cell in Excel. Choose the font, font attributes, color, etc. you want. Select it and choose Edit, Copy Switch to PPT Edit, Paste Special, checkmark next to Link Size and position to taste. > This certainly looks like it would work. Unfortunately, I'd have to purchase > the software and that's not an option. What if I created another spreadsheet [quoted text clipped - 9 lines] > > > speadsheets to the slides so I don't have to manually enter the data each > > > time? Thanks in advance for your help. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================
|
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.