May 09 2023 02:16 PM
I have a linked picture that displays data from a column I want to hide.
When I hide the column, the linked picture disappears.
Is there a way to avoid this?
Thanks,
John
May 10 2023 03:32 AM
To my knowledge, when you hide a column that is the source of a linked picture in Excel, the picture will also disappear.
This is because the linked picture is directly tied to the data in the hidden column.
However, there are a few workarounds you can try:
Overall, while it is not possible to display a linked picture when the linked data column is hidden in Excel, these workarounds can help you achieve a similar result.
May 10 2023 06:09 AM
Thanks for the options. Unfortunately, the first two didn't work out. If I make the column very small, the format of the linked picture is impacted. The cell contains a number so the linked picture turns into ###.
When I name the range, it still disappears when I hide the column.
I'll probably just end up moving the data to another sheet and hide the sheet which appears to work fine. It's not as convenient for me, but it should be fine.
May 10 2023 09:15 AM