 |
 | 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 2006imported tables distorted
Hi I am making reports in Power Point and some of the data is in previous reports and we are told to take to an old table and just copy and paste it. This is where the problem arises, some of the tables no matter what tools I use, will not adjust properly. The font will not take a specific size and not look like it was just stretched out. I have cleared all formatting and still no luck. I insert the slide from the previous report into the one that I am working on. Some of the tables from the old reports have been imported from another program and the original files are not available to cleanly import the file. I know I could redo the table but I am consistently told not to, I should be able to use the existing tables. In a perfect world this would be great! Suggestions would be appreciated, I may be missing the obvious. System, Windows XP 2003 Office Thank you MJ Can you tell me the source of your tables?  SignatureMCSE, MCSA, MCT, MBA www.epsico.com > Hi > I am making reports in Power Point and some of the data is in previous [quoted text clipped - 19 lines] > Thank you > MJ I am not sure of the original source file. Currently the file is taken from another Power Point file. I believe they originated from an Excel. The original files are not available they were not saved separately. It seems as if the past practices had been to save in Power Point and not keep the original file that was used and imported in. MJ > Can you tell me the source of your tables? After you paste the table into the other presentation, right-click it, choose Format Object, and set to 100% x 100% on the size tab. It may overlap your slide at this point, but just OK your way out anyway. Now, does the text look right? If so, then go back to the size tab and change the table size -- but change it proportionately! You can do this by checking "lock aspect ratio" on the size tab. -- Echo [MS PPT MVP] http://www.echosvoice.com > I am not sure of the original source file. Currently the file is taken from > another Power Point file. I believe they originated from an Excel. The [quoted text clipped - 9 lines] > > MCSE, MCSA, MCT, MBA > > www.epsico.com THANK YOU!!!! It worked and has solved many problems. MJ > After you paste the table into the other presentation, right-click it, > choose Format Object, and set to 100% x 100% on the size tab. It may overlap [quoted text clipped - 23 lines] > > > MCSE, MCSA, MCT, MBA > > > www.epsico.com Ah, I'm very happy to hear that. SignatureEcho [MS PPT MVP] http://www.echosvoice.com > THANK YOU!!!! > It worked and has solved many problems. [quoted text clipped - 27 lines] > > > > MCSE, MCSA, MCT, MBA > > > > www.epsico.com so was her issue just a matter of X being different from Y? scaled improportionately? i have issues where my tables look fine until i try editing them, then when i close them, they look terrible in ppt, borders show up, fonts are wrong, all formatting is way off. isnt this a fairly normal practice? shouldnt my excel file look corrent in ppt, even after editing? jeff > Ah, I'm very happy to hear that. > [quoted text clipped - 34 lines] > > > > > MCSE, MCSA, MCT, MBA > > > > > www.epsico.com Yes, I think the original poster's problem was the chart not being proportional on the slide. In your case, you might as well give it a shot; it definitely won't hurt. Here's some additional info to bear in mind when working with charts: http://www.echosvoice.com/charts.htm Now, I have to admit, I've not seen borders show up out of the blue. I'm not sure what the cause would be. And "fonts are wrong" and "all formatting is way off" could be a whole bunch of stuff -- what exactly is going on with the fonts and other formatting? Brian Reilly always suggests putting your charts on chart sheets and then inserting them into PPT. Hang on, lemme see if I can find his instrux. Ahh, yeah, here it is: Problems with LINKED EXCEL CHARTS in PowerPoint http://www.pptfaq.com/FAQ00067.htm You could also try Edit|Paste Special and see if anything there works better for you. 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 > so was her issue just a matter of X being different from Y? scaled > improportionately? [quoted text clipped - 52 lines] >> > > > > MCSE, MCSA, MCT, MBA >> > > > > www.epsico.com thanks for the response echo.. these are charts actually they're xls tables, rows and cells... when edited cell spacing and row heights take on a mind of their own... fonts go left aligned, etc. could the files be taking on properties/defaults of the users application? as opposed to the creator's? > Yes, I think the original poster's problem was the chart not being > proportional on the slide. [quoted text clipped - 70 lines] > >> > > > > MCSE, MCSA, MCT, MBA > >> > > > > www.epsico.com Ah, sorry. I missed where you said tables below -- I was obviously thinking charts, although in retrospect, I've no idea why! How are you pasting the cells into PPT? I'd use Edit|Paste Special and choose Excel Object. Otherwise, you get a PowerPoint table by default, and yes, these will take on various properties of the placeholder in the slide master. 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 > thanks for the response echo.. these are charts actually they're xls > tables, [quoted text clipped - 91 lines] >> >> > > > > MCSE, MCSA, MCT, MBA >> >> > > > > www.epsico.com echo, that brings up a good question that i dont see a clear answer for. WHAT technically is the difference between copying a table from excel and paste special into ppt versus using insert object xls worksheet. i've tried both and both dont like to be edited without reacting funny. thanks jeff
|
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.