Hello All
I have a spreadsheet which is being shared by multiple users. The sheet is protected and I have allowed autofilter to be used. I have dedicated a row which contains the autofilter arrows for each column. This seems to work fine most of the time.
The problem is that the autofilter arrows seem to disappear now and again forcing me to set the autofilter back up. As the sheet is protected no one should be able to turn the autofilter on or off.
Does anyone know why this is happening and how I can prevent it.
Many thanks
Rich
Bookmarks