Unlocking5447
New Member
- Joined
- Sep 19, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I’m having a problem with resolution loss of images inserted into an Excel workbook and, after several hours, still haven’t come up with a solution.
The issue is as follows: I have an Excel workbook with thousands of rows of data. I’ve added a column where I want to place an image for most of these rows. I have already disabled the image compression in the “Options” “Advanced” for the workbook and selected “High Fidelity” for the default resolution. The images are in TIF format, but I have also tried converting them into PNG with the same issues. I am selecting the cell and then inserting the image using the ‘insert’ tab on the ribbon, then “pictures” and “place in cell” etc. (copying and then pasting from the clipboard does not work for some reason). When an image is inserted it looks fine but if I toggle the ‘place in cell’ ‘place over cell’ using the little picture icon at the top right of the image, then the resolution quality is reduced. With some files the reduction is worse than others (I haven’t worked out why this is), but I don’t want any resolution loss at all as this workbook. Here are a couple of examples. In each case the image on the left has not been manipulated after being inserted, the one on the right has been toggled as described above.
Thank you for any assistance you can provide.
Both the ones below show the inserted graph on the left and the toggled graph on the right – both lose resolution, although the second example shows the problem more dramatically.
I’m having a problem with resolution loss of images inserted into an Excel workbook and, after several hours, still haven’t come up with a solution.
The issue is as follows: I have an Excel workbook with thousands of rows of data. I’ve added a column where I want to place an image for most of these rows. I have already disabled the image compression in the “Options” “Advanced” for the workbook and selected “High Fidelity” for the default resolution. The images are in TIF format, but I have also tried converting them into PNG with the same issues. I am selecting the cell and then inserting the image using the ‘insert’ tab on the ribbon, then “pictures” and “place in cell” etc. (copying and then pasting from the clipboard does not work for some reason). When an image is inserted it looks fine but if I toggle the ‘place in cell’ ‘place over cell’ using the little picture icon at the top right of the image, then the resolution quality is reduced. With some files the reduction is worse than others (I haven’t worked out why this is), but I don’t want any resolution loss at all as this workbook. Here are a couple of examples. In each case the image on the left has not been manipulated after being inserted, the one on the right has been toggled as described above.
Thank you for any assistance you can provide.
Both the ones below show the inserted graph on the left and the toggled graph on the right – both lose resolution, although the second example shows the problem more dramatically.
