Mar 12 2021 03:16 AM
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
Mar 12 2021 06:29 AM
Mar 12 2021 06:40 AM
Mar 12 2021 07:06 AM
Mar 12 2021 08:02 AM
Mar 12 2021 08:32 AM
Mar 12 2021 08:44 AM
Mar 12 2021 08:54 AM
Mar 12 2021 10:28 AM
SolutionMar 12 2021 10:28 AM
Solution