Results 1 to 5 of 5
  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort & other features greyed out (Excel 2000/SR-

    My question is what could I have done to cause this & what could I have done to undo it.

    I have Excel 2000 & also ASAP Utilities, which is an add-in from http://www.asap-utilities.com/. At some point in time, I accidentally pressed some keys (something like Ctrl+Shift+C or V or Ctrl+Alt+C or V). In fact, I accidentally pasted something, but immediately pressed Ctrl+Z. A number of menu items became greyed out, including the Sort & SetPrintArea buttons on the toolbar.

    I thought perhaps the spreadsheet was protected, but that wasn't the case. Things like Goal Seek, Scenerios, Solver, & add-ins were greyed out. If I closed Excel & then reopened without ASAP utilities running, the options came back. If I then loaded ASAP, they became greyed out again.

    Somehow, playing around corrected the problem, but I have no idea what it was. Other than protecting the sheet, what could cause this?
    Thanks,

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort & other features greyed out (Excel 2000/S

    A couple of years ago, I downloaded and installed ASAP Utilities - thinking I might increase productivity with it (as a fairly intensive Excel user). Frankly, despite its simple & user-friendly interface, I found it far too complicated & powerful for simple folks such as me. Bottom line: I did not see any of its myriad of impressive features significantly improving productivity over the "bush league" features I had already installed. In fact, I dreaded keeping the two sets of features in line with each other. Phil, I know that this is not the most helpful answer, but...HTH
    Gre

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort & other features greyed out (Excel 2000/S

    Thanks for the response. I actually don't use ASAP that much. The feature I use is to shade every nth row. I find that pretty useful. Still, I'd like to know what could cause this. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort & other features greyed out (Excel 2000/S

    >The feature I use is to shade every nth row.

    Like the add-in in <!post=this post,378992>this post<!/post>?
    Gre

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort & other features greyed out (Excel 2000/S

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15> Uh, yea. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I just emailed him. Thanks.

Posting Permissions

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