+ Reply to Thread
Results 1 to 8 of 8

Unable to Access Some Tools in Excel Spreadsheet

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2011
    Posts
    5

    Unable to Access Some Tools in Excel Spreadsheet

    I am new to Excel and have been working on a downloaded spreadsheet template. Some features are listed on the toolbar but cannot be selected (they are not 'highlighted'). The ones I can't access are the Redo, Sort, Autosum, and Filter options. If I go into the Formulas tab, everything is available except the Autosum. There are several items that I cannot get to under the Data and Review tabs. Is there a way to turn these features on? The ones that I really would like to access are Sort, Autosum and perhaps the spell check. Thank you!

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Unable to Access Some Tools in Excel Spreadsheet

    Hi -

    It may be possible the sheet is protected. Sometimes that prevents you from using tools like sort, filter, etc. You can check if the sheet is protected by going to the Review tab, under Changes, it should say Protect Sheet or Unprotect Sheet, depending on which setting is current.

    If that isn't the problem, it would be helpful if you upload your spreadsheet to this forum (with sensitive or private data removed) so we can take a look at it and see what might be the problem.

    Hope this helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Unable to Access Some Tools in Excel Spreadsheet

    Does the file have a .xlsm extension? there could be a macro running that is disabling those

    Did the file need a password to open? That me be disabling some too?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    04-22-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Unable to Access Some Tools in Excel Spreadsheet

    Quote Originally Posted by FDibbins View Post
    Does the file have a .xlsm extension? there could be a macro running that is disabling those

    Did the file need a password to open? That me be disabling some too?
    I don't know how to discern whether there is a .xlsm extension. Can you explain that process to me?
    No, there's no password required.

  5. #5
    Registered User
    Join Date
    04-22-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Unable to Access Some Tools in Excel Spreadsheet

    I tried to follow your instructions, which seemed clear enough, but when I go to the Review tab, there is no "changes" options; I have "comments," "Protection," and "Share." Under the Protection tab, I have Sheet, Workbook, Password and Permissions. The cells/rows on my spreadsheet do not appear to be locked because I can make changes to them.

    I will try to figure out how to load the spreadsheet for you to see. Thank you.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-22-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Unable to Access Some Tools in Excel Spreadsheet

    The workbook is saved as a ".xls" - but I don't see the .xlsm???

  7. #7
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Unable to Access Some Tools in Excel Spreadsheet

    yep, the sheet is protected.

    Right click on the sheet's Tab, and select "Unprotect Sheet"

  8. #8
    Registered User
    Join Date
    04-22-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Unable to Access Some Tools in Excel Spreadsheet

    Got it! It was locked & you guys helped me figure it out. Thanks, ya'll!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1