Say I've an Excel spreadsheet with sensitive data in it that I wish to share in such a way that I can only let other users see the data filtered by my filter column.
If I put a 1 in the allow column then they must be able to see the data in it.
I'm aware of protecting the Sheets - can you think of another way?
I was attempting to create a data source to it and defining a query that only selects the data where there is a 1 in the 'allow' column - but as soon as I protect the source xls an error - encrypted data is returned - cannot read by the xls.
Any suggestions please?