Disable or remove the magnifying glass filters on a particular sheet which is a straight table
Users will filter on sheet A (straight table) and a small subset of these columns are on sheet B (straight table). The user will then download the data on sheet B into Excel for further processing. Sheet B is not meant to by filtered and I wouldn't want the filter to be changed on sheet B as it will carry through back to sheet A and the other sheets. Is there any way of stopping the ability to filter on a specific straight table sheet? Thanks.