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.
Saturday, July 18, 2009 5:13 PM
- Edited by Pete_J Saturday, July 18, 2009 5:14 PM
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 AMModerator
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