Hi,
I was trying to get such report, it's generating, but there are few glitches.
I have created separate sheets for everyone but the sheets, when shared out, allow the filter to be used (allowing other users access to other data).
How can I shut that off? If I protect the worksheet, the user can not use the excel file to manipulate the data on their own worksheet.
Any ideas?
I was trying to get such report, it's generating, but there are few glitches.
I have created separate sheets for everyone but the sheets, when shared out, allow the filter to be used (allowing other users access to other data).
How can I shut that off? If I protect the worksheet, the user can not use the excel file to manipulate the data on their own worksheet.
Any ideas?