Hi all, so bit of a confusing one.
I have a workbook with one worksheet in it (used by Team A) that is a replica of a worksheet (source sheet) in another workbook that other colleagues use/populate/edit (Team B). It's designed so as to pull through data from a working sheet that Team B are using, for info only so that Team A can see the content when they need to.
I want to lock this tab down, so I protect the sheet, but every time I then click on a cell, it seems to want to open this source data workbook - any ideas how I can stop it from doing this?
I have a workbook with one worksheet in it (used by Team A) that is a replica of a worksheet (source sheet) in another workbook that other colleagues use/populate/edit (Team B). It's designed so as to pull through data from a working sheet that Team B are using, for info only so that Team A can see the content when they need to.
I want to lock this tab down, so I protect the sheet, but every time I then click on a cell, it seems to want to open this source data workbook - any ideas how I can stop it from doing this?
