Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Data Filter issue

  1. #1
    Board Regular
    Join Date
    May 2017
    Posts
    147
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Filter issue

    I've inherited two spreadsheets (Yr 8 Math 2017 and Yr 9 Math 2017), both have a filter on the range MARKS!$A$4:$FK$359

    The filters work fine on the Yr 8 2017 spreadsheet, whether the sheet (MARKS) is protected or not ... ie: the user can click on a filter and filter as required.

    The filters on the Yr 9 Math 2017 spreadsheet only allow the user to use them when the worksheet (MARKS) is unprotected. When it's protected, the filters cannot be activated.

    Does anyone have an idea as to what the creator of the two spreadsheets might have done with the Year 9 spreadsheet that's causing the filters to not be activated when the sheet is protected ?

    I'm using Excel 2013.

    Kind regards,

    Chris
    Last edited by palaeontology; Aug 13th, 2017 at 07:32 AM.

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,402
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Data Filter issue

    When you protect a worksheet you have the option of whether to allow users to use AutoFilter or not. Seems like the creator has allowed it on one but not the other.
    On a fresh worksheet, look at manually Protecting it (on the Review ribbon tab) and look at the options available in that dialog box.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

  3. #3
    Board Regular
    Join Date
    May 2017
    Posts
    147
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Filter issue

    Peter, thankyou, so much, for that solve.

    I had completely forgotten about the option to allow autofilter or not.

    And my apologies too for not responding to some of the assistance I've received in recent days.

    I'm usually pretty on top of that sort of thing, but I've allowed to let things get away from me.

    My apologies again,

    Kind regards,

    Chris

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,402
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Data Filter issue

    Quote Originally Posted by palaeontology View Post
    Peter, thankyou, so much, for that solve.

    I had completely forgotten about the option to allow autofilter or not.
    No problem.


    Quote Originally Posted by palaeontology View Post
    And my apologies too for not responding to some of the assistance I've received in recent days.

    I'm usually pretty on top of that sort of thing, but I've allowed to let things get away from me.

    My apologies again,

    Kind regards,

    Chris
    So, is there any chance we can progress this one too?
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com