Back to Blog
![]() ![]() This will allow the linked picture to access the data even when the column is hidden. Use a macro: You can create a macro that will unhide the column when the worksheet is opened, and then hide the column again when the worksheet is closed.When you hide the column, the named range will still be visible, and the linked picture will still be able to access the data. Then, link the picture to the named range instead of the column. Use a named range: Instead of linking directly to the column, you can create a named range that includes the data in the column.This will effectively hide the column, but the linked picture will still be able to access the data. Resize the column: Instead of hiding the column, you can resize the column to make it very narrow.However, there are a few workarounds you can try: This is because the linked picture is directly tied to the data in the hidden column. My knowledge, when you hide a column that is the source of a linked picture in Excel, the picture will also disappear. ![]()
0 Comments
Read More
Leave a Reply. |