Forum Discussion
Solved
Problem with a linked picture in Excel file.
Hi. I have a 3 x sheet (data, collation, final table) Excel file.
The table updates as the data changes.
I have highlighted and copied the table and then under Home tab have placed this table in sheet 1(data) as a linked picture. Fine. As the data changes the table updates. I have then hidden and protected the sheets and file so there is just one ‘page’.
The problem: when I share the file with someone, even if they download it from Onedrive, the linked picture is missing from the screen. How can I fix this? Thanks for any help. Dennis
- Hi. I will keep you posted if I find a solution without going back to the beginning. At the time I thought about designing it so it was on the first sheet but I am now where I am. Thanks and I will be in touch if ..Dennis
8 Replies
- Is it because that other sheet is protected &/or hidden?
- Hi. I don't know but I don't think so. The hidden sheet/table does not stop the the table updating with me. I thought maybe there is a better way to link the table other than as a linked picture so that it updates but retains the format of the underlying table. Thanks for your input. Dennis
- couldn't you just use a formula like ='Final Table'!A1:X99 to repeat the table and then you can add protection on this data sheet to protect those cells but leave the areas they need to edit unlocked? To that end, why even have the table on another sheet? Maybe because I don't have the file I'm just not getting the whys or hows.
