 |
 | 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 / August 2006How do I link data from Excel to a PowerPoint slide?
I've read the various responses to this question, and managed to link the data from an Excel spreadsheet to a PowerPoint slide. However, the data appears in a box, and the font is quite small. How can I remove the box and increase the size of the font so it will be the same size as the other text on the slide? Thanks for your time? Well, how did you create the link?  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 > I've read the various responses to this question, and managed to link the > data from an Excel spreadsheet to a PowerPoint slide. However, the data [quoted text clipped - 3 lines] > text > on the slide? Thanks for your time? Copied the data from the source file, opened the destination file, clicked Edit, Paste Special, Paste as Link. > Well, how did you create the link? > [quoted text clipped - 5 lines] > > text > > on the slide? Thanks for your time? Okay, thanks. To get rid of the gridlines, you'll have to turn them off in Excel. In Excel, go to Tools|Options|View and uncheck Gridlines. You should also change the font size in the Excel spreadsheet. Then in PPT, you can right-click the linked Excel object, choose Format Object, and make sure it's set to 100% x 100% in the Size tab. (It should come in at that 100% size, but if it doesn't, that's where you can change it.) 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 > Copied the data from the source file, opened the destination file, clicked > Edit, Paste Special, Paste as Link. [quoted text clipped - 9 lines] >> > text >> > on the slide? Thanks for your time? Another question on this same subject. Is there any way to make the links "unbreakable" in instances where someone may move the source file? And what will happen if the source file is sorted? Does this have any effect on the linked file? > Okay, thanks. > [quoted text clipped - 19 lines] > >> > text > >> > on the slide? Thanks for your time? > Another question on this same subject. Is there any way to make the links > "unbreakable" in instances where someone may move the source file? Not that I'm aware. I'll confess that this kind of linking isn't my strong suit, though. You might want to check into FixLinks Pro http://www.rdpslides.com/pptools/fixlinks/index.html and see if it will help you. It won't prevent link breakage, but it does help fix them if they're broken. Or you might check in the Edit|Links menu in PPT -- I'm not sure how reliable "change source" is there, but it would be worth looking at if you end up with a broken link. > And what > will happen if the source file is sorted? Does this have any effect on the > linked file? When you open the PPT file, you should be prompted to update links or not. If you update them, the display in the PPT file will reflect any changes (such as sorting) that have been made to the linked Excel file. 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 > Another question on this same subject. Is there any way to make the links > "unbreakable" in instances where someone may move the source file? If you embed the information rather than linking, the source file will no longer be required. With linked Excel content, PPT will generally find the linked file if it's in the same folder as PPT or if it's wherever the link points. Otherwise, no, and nothing much can be done about it. > And what > will happen if the source file is sorted? Does this have any effect on the > linked file? The link points to the file and a range of cells within the file. Sorting will most likely change the data that's in that range, so PPT will display the new contents of the range the next time you open the PPT and the link is updated. > > Okay, thanks. > > [quoted text clipped - 19 lines] > > >> > text > > >> > on the slide? Thanks for your time? ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Thanks, Echo. This solved the problem. Jan > Okay, thanks. > [quoted text clipped - 19 lines] > >> > text > >> > on the slide? Thanks for your time? |
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.