Excel charts in PowerPoint

[Henrik]

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

 

[Henrik]

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