Forum Discussion
JohnG768
May 09, 2023Copper Contributor
Show Linked Picture When Linked Data Column is Hidden
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
JohnG768
May 10, 2023Copper Contributor
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.
NikolinoDE
May 10, 2023Platinum Contributor
picture turns into ###
Recommend formatting cells (right mouse button) > Alignment > Text control > Fit to cell size (tick)
Recommend formatting cells (right mouse button) > Alignment > Text control > Fit to cell size (tick)