A short post today on an ‘annoyance’ that invariably pops up at my clients; when copy and pasting images of QlikView objects into their PowerPoint presentation or Word document, the images look blurry and slightly out of focus.
Fortunately, there is an easy way to solve this. Instead of using the regular paste option, use paste special to paste the image as a bitmap.
In both Office 2007 and 2010, the paste special option can be accessed via the paste drop-down menu on the left of the Home tab/ribbon, or via the Ctrl + Alt + V keyboard shortcut.
That’s it!
6 Comments
This is a really useful tip – thanks for sharing Barry.
Any way to do this when pasting an image into an Outlook message via a macro?
Hi Brian,
That should not be a problem, replace the Paste method with PasteSpecial and set the DataType parameter to wdPasteBitmap, so .PasteSpecial DataType:=wdPasteBitmap.
Cheers,
Barry
Thanks, I’ll give it a try.
Barry,
Works great for Excel but I had no luck with Powerpoint 2007. I think that’s because Powerpoint 2007 seems to have anti-aliasing turned on by default and I don’t think it can be turned off.
Grant
It’s actually to do with the scaling in Powerpoint. As long as the graphic is at 100% scaling (size and position on the right click on the graphic) it shows as sharp. The paste special bitmap tends to paste at 100% if you are not pasting into a content placeholder.