I want to create a new workbook which displays only a subset of columns from the source workbook and also automatically updates everytime there's a change in the source file.
The new workbook should allow the users to just filter/sort but shouldn't allow to edit. The users shouldn't be accessing or viewing data in the source workbook.
The source workbook has restricted user access. Can you help me how this can be achieved?
The new workbook should allow the users to just filter/sort but shouldn't allow to edit. The users shouldn't be accessing or viewing data in the source workbook.
The source workbook has restricted user access. Can you help me how this can be achieved?
