fareedexcel
Member
Dear Experts,
I have an issue with filtering a protected sheet. I have around 500 rows where I need to protect the sheet. When I protected the sheet and tried to filter. I'm getting a message to unprotect the sheet and do the filter.
Even I tried with Review -> Allow users to track changes. But this too not helping. Kindly assist on the best solution to make this happen.
Regards,
Ahamed
I have an issue with filtering a protected sheet. I have around 500 rows where I need to protect the sheet. When I protected the sheet and tried to filter. I'm getting a message to unprotect the sheet and do the filter.
Even I tried with Review -> Allow users to track changes. But this too not helping. Kindly assist on the best solution to make this happen.
Regards,
Ahamed