Pasting Excel Charts as Enhanced Metafiles

[Donahue]

Since upgrading to Office 2003, I am unable to
successfully paste Graphs made in Excel as enhanced
metafiles into my office's Microsoft Word report template.

When I paste special, as an enhanced metafile, I am only
able to see the very bottom piece of the graph. I can
move the graph around and resize it, but it will not show
up on screen. Nor does it show up in print preview. BUT
it comes out just fine when I print a hard copy.

This issue is unique to our report template, as I can
paste Excel graphs into a blank Word document with no
trouble.

But it is also unique to Excel, as I can successfully
paste graphs made in Power Point into our report template.

I've tried re-creating the template in 2003 but that did
not help. I've also tried every combination of Office
2000 and 2003 pastes (i.e. graphs made in Excel 2003 into
the 2000 template, graphs made in Excel 2000 into the 2003
template, etc). Nothing seems to work.

Has anyone seen this problem before? Any suggestions on
how to get aorund it?

 

[Jon Peltier]

What if you copy the chart as a picture in Excel? Hold shift while
selecting Copy Picture from the Edit menu, then use the On Screen and
Picture (not Bitmap) options.

Otherwise, it sounds like something fishy with your template.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Donahue]

Thanks, Jon.

Our designer's on paternity leave but we're hoping to have
him redo the template when he returns. Meanwhile, we'll
try your suggestion and post back with results.

 

[Guest]

I've just tried copying the excel chart as a picture (not
bitmap). But when I Paste Special as a metafile I still
have the same problem.

Any other suggestions?

 

[Jon Peltier]

If you copy it as a picture (not bitmap), all you have to do in Word is
Paste, not Paste Special. See if that helps.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______