+ Reply to Thread
Results 1 to 2 of 2

Inserting Images into Excel

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-13-2010
    Location
    England
    MS-Off Ver
    Office 2016 365
    Posts
    211

    Inserting Images into Excel

    Hi all,

    I have inherited a workbook that has a sheet with an image of a word document in it (its a set of terms and conditions on 1 page)

    Anyway, the image is very crisp and when printed comes out in a good resolution.

    We have recently had to alter the text though. So, i have pdf'd the word doc and then saved as .jpeg, .tif and .png. The .jpeg lost a lot of resolution and doesn't look good.

    However, when opening the .tif and .png files on their own i am presented with a very good, crisp image of the word document.

    However, when i then insert either of those files into the Excel Worksheet - the image presented has lost a lot of its clarity and quality.

    I have tried inserting the document as an object but a) the formatting goes wrong and b) it "breaks" a macro that needs to run

    Does anyone know how to insert a high quality image, that will retain that quality, into an excel work sheet?

    Thanks in advance

    James

    (Windows 7, Office 2010)

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Inserting Images into Excel

    JPEG is a high-compression format; the flip side is, it's notorious for lossy images, especially when you're trying to represent text.

    (TIF and PNG are newer formats with less artifaction, so they tend to look better.)

    PDF... by design, they're relatively small files, which exactly means you have fewer pixels for any image.

    Excel doesn't know what TIF or PNG are so it's probably just forcing those images into the JPEG format. (Well, probably a bitmap, actually).

    Personally, I would avoid this daisy-chain of word => pdf => image => excel, because each of those formats has different priorities (text vs picture), so what you're doing is stacking all of their "throw out the low priority data to save space" on top of each other and ruining your image quality.

    Microsoft already has a straight-forward way to embed Word in Excel that will allow you to avoid that whole mess. Especially if you have the .doc file to work with.
    Last edited by ben_hensel; 06-08-2012 at 10:23 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1