If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy from Excel into Powerpoint - picture changes
I have a problem in XP copying from Excel to Powerpoint.
I have run the same process of copying in Windows 2000 and it works but it fails when I try it in XP. I copy a selection of Excel cells that includes a graph, title & text boxes and copy into Powerpoint as a picture. In Win 2000 I used the Paste Special, Picture option and then resized the picture, no problems, it is a perfect copy. In XP I used the Paste Special, Picture (both windows and enhanced options), this then however changes the layout of the copied in cells (the title, text boxes and graph all move position slightly so that the resultant picture has things in the wrong place), it changes both the Powerpoint picture & the original Excel is changed as well, even though all I have done is copy from Excel to Powerpoint. The only solution in XP appears to be to copy & paste as a Paste Special, Device Independent Bitmap, the problem then is that the granularity of the picture is not very detailed so the numbers look fuzzy when you print them. The only proper solution is to go back to using or borrowing a Windows 2000 PC. Please let me know how to fix this problem, in theory upgrading to XP should result in an improvement not a step backwards in functionality !. FYI I am using a brand new Dell Optiplex GX270 with a Pentium 4 3.2ghz with 256mb RAM. I have installed XP Version 2002 Service Pack 1, 5.1.2600 with MS Powerpoint 2003 (11.5529.5606) & Excel 2003 (11.5612.5606). I look forward to your response Andrew Wood |
#2
|
|||
|
|||
Copy from Excel into Powerpoint - picture changes
Andrew,
I did some preliminary testing here. If I highlight cells and a chart in Excel, and paste into PowerPoint, I get a resultant table which includes the cells and a chart. But it is all a mess. Same if I just copy cells and paste in PowerPoint. I didn't get any change in the source file, though. I guess what is happening is you are getting a paste result that is based on a table, and it is not satisfactory. The solution may depend on your requirements. But first, when you paste, you should get a little smart tag button appear near the pasted content in PowerPoint. You can click it and change your resultant paste option. If you paste a copied chart, you get it pasted as an Excel worksheet. You can hit the button and also change that to a picture of the chart. However, for both cells *and* a chart, I'd recommend personally one of two options. One is to copy and paste link it into PowerPoint. But any changes in Excel will update in PowerPoint. Else, as you have started to find out, it may be better to paste special as an image. My preference is for some sort of format like wmf or emf. These are not just bitmaps, but contain vector information that you can regain by busting them up into objects (try paste special of a chart...wmf, right click on the pasted chart, ungroup, turn to drawing object and ungroup again). Hope that helps. -- Regards, Glen Millar Microsoft PPT MVP http://www.powerpointworkbench.com/ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego CA http://www.powerpointlive.com "Andrew Wood" wrote in message ... I have a problem in XP copying from Excel to Powerpoint. I have run the same process of copying in Windows 2000 and it works but it fails when I try it in XP. I copy a selection of Excel cells that includes a graph, title & text boxes and copy into Powerpoint as a picture. In Win 2000 I used the Paste Special, Picture option and then resized the picture, no problems, it is a perfect copy. In XP I used the Paste Special, Picture (both windows and enhanced options), this then however changes the layout of the copied in cells (the title, text boxes and graph all move position slightly so that the resultant picture has things in the wrong place), it changes both the Powerpoint picture & the original Excel is changed as well, even though all I have done is copy from Excel to Powerpoint. The only solution in XP appears to be to copy & paste as a Paste Special, Device Independent Bitmap, the problem then is that the granularity of the picture is not very detailed so the numbers look fuzzy when you print them. The only proper solution is to go back to using or borrowing a Windows 2000 PC. Please let me know how to fix this problem, in theory upgrading to XP should result in an improvement not a step backwards in functionality !. FYI I am using a brand new Dell Optiplex GX270 with a Pentium 4 3.2ghz with 256mb RAM. I have installed XP Version 2002 Service Pack 1, 5.1.2600 with MS Powerpoint 2003 (11.5529.5606) & Excel 2003 (11.5612.5606). I look forward to your response Andrew Wood |
#3
|
|||
|
|||
Copy from Excel into Powerpoint - picture changes
Andrew,
I did some preliminary testing here. If I highlight cells and a chart in Excel, and paste into PowerPoint, I get a resultant table which includes the cells and a chart. But it is all a mess. Same if I just copy cells and paste in PowerPoint. I didn't get any change in the source file, though. I guess what is happening is you are getting a paste result that is based on a table, and it is not satisfactory. The solution may depend on your requirements. But first, when you paste, you should get a little smart tag button appear near the pasted content in PowerPoint. You can click it and change your resultant paste option. If you paste a copied chart, you get it pasted as an Excel worksheet. You can hit the button and also change that to a picture of the chart. However, for both cells *and* a chart, I'd recommend personally one of two options. One is to copy and paste link it into PowerPoint. But any changes in Excel will update in PowerPoint. Else, as you have started to find out, it may be better to paste special as an image. My preference is for some sort of format like wmf or emf. These are not just bitmaps, but contain vector information that you can regain by busting them up into objects (try paste special of a chart...wmf, right click on the pasted chart, ungroup, turn to drawing object and ungroup again). Hope that helps. -- Regards, Glen Millar Microsoft PPT MVP http://www.powerpointworkbench.com/ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego CA http://www.powerpointlive.com "Andrew Wood" wrote in message ... I have a problem in XP copying from Excel to Powerpoint. I have run the same process of copying in Windows 2000 and it works but it fails when I try it in XP. I copy a selection of Excel cells that includes a graph, title & text boxes and copy into Powerpoint as a picture. In Win 2000 I used the Paste Special, Picture option and then resized the picture, no problems, it is a perfect copy. In XP I used the Paste Special, Picture (both windows and enhanced options), this then however changes the layout of the copied in cells (the title, text boxes and graph all move position slightly so that the resultant picture has things in the wrong place), it changes both the Powerpoint picture & the original Excel is changed as well, even though all I have done is copy from Excel to Powerpoint. The only solution in XP appears to be to copy & paste as a Paste Special, Device Independent Bitmap, the problem then is that the granularity of the picture is not very detailed so the numbers look fuzzy when you print them. The only proper solution is to go back to using or borrowing a Windows 2000 PC. Please let me know how to fix this problem, in theory upgrading to XP should result in an improvement not a step backwards in functionality !. FYI I am using a brand new Dell Optiplex GX270 with a Pentium 4 3.2ghz with 256mb RAM. I have installed XP Version 2002 Service Pack 1, 5.1.2600 with MS Powerpoint 2003 (11.5529.5606) & Excel 2003 (11.5612.5606). I look forward to your response Andrew Wood |
#4
|
|||
|
|||
Copy from Excel into Powerpoint - picture changes
You might try turning off under Tools | Auto Correct Options... | Autocorrect
as you type | remove the checkmark from Automatic layout for inserted objects. -- Please post all follow-up questions/replies to the newsgroup Email unless specifically requested will not be opened Do Provide The Version Of PowerPoint You Are Using Do Not Post Attachments In This Newsgroup Michael Koerner [MS PPT MVP] "Andrew Wood" wrote in message ... I have a problem in XP copying from Excel to Powerpoint. I have run the same process of copying in Windows 2000 and it works but it fails when I try it in XP. I copy a selection of Excel cells that includes a graph, title & text boxes and copy into Powerpoint as a picture. In Win 2000 I used the Paste Special, Picture option and then resized the picture, no problems, it is a perfect copy. In XP I used the Paste Special, Picture (both windows and enhanced options), this then however changes the layout of the copied in cells (the title, text boxes and graph all move position slightly so that the resultant picture has things in the wrong place), it changes both the Powerpoint picture & the original Excel is changed as well, even though all I have done is copy from Excel to Powerpoint. The only solution in XP appears to be to copy & paste as a Paste Special, Device Independent Bitmap, the problem then is that the granularity of the picture is not very detailed so the numbers look fuzzy when you print them. The only proper solution is to go back to using or borrowing a Windows 2000 PC. Please let me know how to fix this problem, in theory upgrading to XP should result in an improvement not a step backwards in functionality !. FYI I am using a brand new Dell Optiplex GX270 with a Pentium 4 3.2ghz with 256mb RAM. I have installed XP Version 2002 Service Pack 1, 5.1.2600 with MS Powerpoint 2003 (11.5529.5606) & Excel 2003 (11.5612.5606). I look forward to your response Andrew Wood |
#5
|
|||
|
|||
Copy from Excel into Powerpoint - picture changes
You might try turning off under Tools | Auto Correct Options... | Autocorrect
as you type | remove the checkmark from Automatic layout for inserted objects. -- Please post all follow-up questions/replies to the newsgroup Email unless specifically requested will not be opened Do Provide The Version Of PowerPoint You Are Using Do Not Post Attachments In This Newsgroup Michael Koerner [MS PPT MVP] "Andrew Wood" wrote in message ... I have a problem in XP copying from Excel to Powerpoint. I have run the same process of copying in Windows 2000 and it works but it fails when I try it in XP. I copy a selection of Excel cells that includes a graph, title & text boxes and copy into Powerpoint as a picture. In Win 2000 I used the Paste Special, Picture option and then resized the picture, no problems, it is a perfect copy. In XP I used the Paste Special, Picture (both windows and enhanced options), this then however changes the layout of the copied in cells (the title, text boxes and graph all move position slightly so that the resultant picture has things in the wrong place), it changes both the Powerpoint picture & the original Excel is changed as well, even though all I have done is copy from Excel to Powerpoint. The only solution in XP appears to be to copy & paste as a Paste Special, Device Independent Bitmap, the problem then is that the granularity of the picture is not very detailed so the numbers look fuzzy when you print them. The only proper solution is to go back to using or borrowing a Windows 2000 PC. Please let me know how to fix this problem, in theory upgrading to XP should result in an improvement not a step backwards in functionality !. FYI I am using a brand new Dell Optiplex GX270 with a Pentium 4 3.2ghz with 256mb RAM. I have installed XP Version 2002 Service Pack 1, 5.1.2600 with MS Powerpoint 2003 (11.5529.5606) & Excel 2003 (11.5612.5606). I look forward to your response Andrew Wood |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixing Excel and Powerpoint in a macro | Ikeriba | General Discussion | 1 | July 21st, 2004 01:27 PM |
take embedded excel spreadsheet in powerpoint out and into excel | Dan Orth | Powerpoint | 3 | June 13th, 2004 03:24 AM |
Inserting Excel into PowerPoint | [email protected] | Powerpoint | 1 | June 1st, 2004 07:12 PM |
Link to PowerPoint from Excel | jchromicz | Worksheet Functions | 0 | May 5th, 2004 06:21 PM |
VBA - Excel chart to Powerpoint linked chart | Ben | Charts and Charting | 0 | February 11th, 2004 10:17 AM |