Hi Abhi,
Rather than paste special, you can try Insert->object command and insert excel workbook as Object to your Presentation. After inserting, resize object. I hope this will solve your problem. Regards, Upendra Singh +91-9910227325, +91-9310760597 ---------------------------------------------------------------------------- --------------------------------- There are 10 kinds of people: Those who understand binary and those who don't. ---------------------------------------------------------------------------- --------------------------------- -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Abhi Sent: Wednesday, July 22, 2009 9:10 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Pasting as "Link" or "Embedding" from Excel 2007 to Powerpoint 2007 Hello, I come across a lot of situations where in I need to link data (A range of cells from Excel (2007 for Windows) or charts) into Powerpoint (2007 for Windows) and then have them automatically updated as the information chages in Excel. The problem which I always face is formatting. Once I paste the information into Powerpoint (using the "Paste-special" method") Powerpoint automatically rezises the object into a smaller size and distorts the font. Also when the information is updated in Excel and I say update links in Powerpoint, the object is resized and the fonts are also distorted. Can someone please let me know how to prevent this from happening? I found from one of the discussion groups that you can prevent auto- resizing by un-checking the "Automatic Layout for inserted objects" in the auto correct options. I am amazed that this option is not available to me in Powerpoint 2007. I only have "Automatic bullets" "Autofit Title text" and "Autofit Body Text". Any solutions? -- Regards, Abhi --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
