SOLVED

Problem with a linked picture in Excel file.

%3CLINGO-SUB%20id%3D%22lingo-sub-2204916%22%20slang%3D%22en-US%22%3EProblem%20with%20a%20linked%20picture%20in%20Excel%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2204916%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20have%20a%203%20x%20sheet%20(data%2C%20collation%2C%20final%20table)%20Excel%20file.%3C%2FP%3E%3CP%3EThe%20table%20updates%20as%20the%20data%20changes.%3C%2FP%3E%3CP%3EI%20have%20highlighted%20and%20copied%20the%20table%20and%20then%20under%20Home%20tab%20have%20placed%20this%20table%20in%20sheet%201(data)%20as%20a%20linked%20picture.%20Fine.%20As%20the%20data%20changes%20the%20table%20updates.%20I%20have%20then%20hidden%20and%20protected%20the%20sheets%20and%20file%20so%20there%20is%20just%20one%20%E2%80%98page%E2%80%99.%3C%2FP%3E%3CP%3EThe%20problem%3A%20when%20I%20share%20the%20file%20with%20someone%2C%20even%20if%20they%20download%20it%20from%20Onedrive%2C%20the%20linked%20picture%20is%20missing%20from%20the%20screen.%20How%20can%20I%20fix%20this%3F%20Thanks%20for%20any%20help.%20Dennis%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2204916%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2205305%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20a%20linked%20picture%20in%20Excel%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2205305%22%20slang%3D%22en-US%22%3EIs%20it%20because%20that%20other%20sheet%20is%20protected%20%26amp%3B%2For%20hidden%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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

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.
Hi. Using a formula as you suggest brings the data from the table in to the sheet but the formatting doesn't come with it. I could re-do the whole thing with the table on the ist sheet to begin with but I then have to re-do all of the formulae again.
If you copy (or cut) and paste the table won't all the formatting come with it? In the other option you can also copy and past formatting only. You can also use the paint brush to copy formatting. Again, without the workbook, it is hard to understand what the specific challenge(s) and providing actual examples of solutions.
Back to your original question about the linked picture. I created one and uploaded it to a sharepoint server and tried to view it in the browser and found:
a) it isn't supported by the browser version
b) and if you click edit it will get removed so even if you then click download to desktop version you will download a version without the linked picture
c) I'm wondering what version of desktop are they running and if maybe the linked image isn't supported in their desktop versions.
Thanks for your input. For now I am going to assume I don't find a fix and will email to recipients as opposed to making a link to Onedrive or Dropbox for a download. Meanwhile, I'll work on other minor tweaks and let the problem mill around in my mind. Thanks again. Dennis
Please update me if you find what the problem or solution is, I would love to know more.
I am in the process of converting a macro-based user login workbook that shows their individual training records into a hybrid version that users can access and use in the browser (or desktop app) and this linked image might be handy (but luckily I haven't encountered your issue yet because I went with the cell based copy of info for what I have done so far)
best response confirmed by DennisMetro (Occasional Contributor)
Solution
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