Excel charts in PowerPoint

[Guest]

Question 1

When I copy an Excel chart into PowerPoint, PasteSpecial does not allow me
to paste link -- the box is greyed out. I get the option to paste the chart
as MS Office Drawing Object, Picture (Windows Metafile) and Picture
(EnhancedMetafile)

What do I need to do?


Question 2

I've also tried to use the 'reduce size' embedding suggested by Brian Reilly
and reproduced by Steve Rindsberg on
http://www.rdpslides.com/pptfaq/FAQ00593.htm. When I do, double clicking on
the chart reveals the original Excel file with the chart page I'd copied into
a new workbook as an additional page.

Again, what do I need to do?


Thanks in advance
Henrik

 

[Guest]

Now I can do both, without having made any changes to settings, rebooted or
similar. Strange. Has anybody else experienced such n erratic behaviour?

 

[Brian Reilly, MVP]

Henrik,
Paste Link is only available after the Excel file has been saved. You
probably hadn't saved it yet when you tried that.

The second point is expected as well. The Excel file retains the link
to the original source workbook. It was a trick we used to use in PPT
97 which didn't have the PasteSpecial method available in VBA code.

Brian Reilly, MVP

 

[Steve Rindsberg]

Now I can do both, without having made any changes to settings, rebooted or
similar. Strange. Has anybody else experienced such n erratic behaviour?

Here's a guess:

The first time, you copied the content from Excel, started PPT then tried to Edit,
Paste Special.

The second time, you already had PowerPoint running when you tried the copy/paste
special.

If you're running certain add-ins (Adobe's PDF add-ins for example) they put stuff
on the clipboard when PPT starts up. That wipes out whatever you put there from
Excel, leaving just a picture of their icon.

That's why you see the odd behavior in the first case but not the second.

Does that seem to match what you're seeing?