Hi all
I have set up a shared workbook for my team which has 11 identical sheets (for each person on the teams workload) which have autofilter on this workbook has been shared and there have been no issues for months.
I have recently made ammendments to the appearance of the spreadsheet and created a new one. However with this when the users open the file the autofilter will only work for some users. It will work on all sheets on some PC's and on none on others.
Any ideas?
I have set up a shared workbook for my team which has 11 identical sheets (for each person on the teams workload) which have autofilter on this workbook has been shared and there have been no issues for months.
I have recently made ammendments to the appearance of the spreadsheet and created a new one. However with this when the users open the file the autofilter will only work for some users. It will work on all sheets on some PC's and on none on others.
Any ideas?