Copy Paste Enhanced Metafile from Excel to Word RRS feed

  • Question

  • Hi,

    We are copying data and charts from Excel to Word as Enhanced Metafile, using copy as picture and using the printer device for maximum quality (Enhanced Metafailes are resizable without degredation of quality).
    We find that, as our printers are multifunctional devices and set to print in black and white (at the print server) then text color copies across as black and white. However the cell background and chart objects copy across in color.
    We have worked around this by temporarily changing the printer driver to use the XPS driver and then later (after copying is complete) back to the default printer, however this adds unacceptable overhead to the copy feature.

    We have a couple more workarounds up our sleeves, but would like to address this at source

    Why is the colored text being copied across in black and white for Enhanced Metafiles where colored cell background and charts copy across in color? We see this in Office 2003 and 2007 and are on Windows XP. 

    Thanks in advance and anticipation of your help.

    • Edited by Pete_J Saturday, July 18, 2009 5:14 PM
    Saturday, July 18, 2009 5:13 PM


All replies

  • Hi, thanks for the post. Let me ask one question do you want both text and background as colored or B&W? Again, Try to use a color printer as a default printer and let us know the output.
    Friday, July 24, 2009 12:32 AM
  • Thanks for the response.

    We want the same colours to come through to Word as per the original Excel workbook. So if the text font is cooured in Excel, it should come throug to Word coloured.

    We know that this works when the printer driver is set to colour as there seems to be a dependency on the printer driver when copy and pasting as enhanced metafile.

    The question is, what can we do in our case, where the printers have been set to black and white for cost-cutting (as the company does not want the users to be printing in colour all the time) - we still want copy-paste to work in colour.

    Many thanks.

    Monday, August 10, 2009 7:59 PM
  • Your issue might get resolved after applying the Hotfix mentioned below:


    Let us know the output.

    Tuesday, September 1, 2009 11:12 PM
  • Marking this thread as answered as we did not receive any reply for more than one week.
    Wednesday, September 9, 2009 8:12 PM