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 sh...
- 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
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. 😞