Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    We have set up a worksheet using Auto-Filter. When we filter the data and save the file, most people can open the file and see the filtered data only. There are some people who see the worksheet with all the data and not auto-filter arrows (Auto-Filter turned off). Is there a setting that prevents Auto-Filtering from being seen?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The AutoFilter status is stored with the workbook. Perhaps an add-in on those users' computers is interfering with AutoFilter. As far as I know, there is nothing you can do about that - it's a problem on the users' side. You could point them to Jan Karel Pieterse's Systematic Approach to behavioral Problems in XL.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks, Hans.

    You confirm that it is something that these particular users are doing. My first guess is that they are not selecting the same file. I will check further with the users.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •