Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    More functions missing (Excel 97 SR2 (Dutch))

    When you type = in a cell, the name box in the formula bar becomes the function box. It is a dropdown list displaying the most recently used functions and an item "More functions" (I don't know the exact caption in English). At least, it used to be that way.
    The "More functions" item has disappeared some time ago, both at work and at home. See attached picture (screenshot added 7/19/2002 11:30 UTC)

    The following actions haven't helped:

    Starting Excel with the shift key down.
    Removing *.xlb (although that hasn't anything to do with this problem AFAIK)
    Running "...Excel.exe" /regserver
    Removing the MRUFuncs registry value.
    Re-installing Office 97.

    Does anyone know how I can get "More functions" back?

    TIA,
    Hans
    Attached Images Attached Images
    • File Type: gif x.gif (2.6 KB, 0 views)

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: More functions missing (Excel 97 SR2 (Dutch))

    HansV,

    You are probably looking for the Add-in "Morefunc" created by Laurent Longre.
    You can get it from his web site at...
    http://longre.free.fr/
    If you read French you won't have a problem.

    Jim Cone
    San Jose, CA USA

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: More functions missing (Excel 97 SR2 (Dutch))

    Hello Jim,

    Thank you for taking the time to respond.

    However, my question is not about obtaining additional functions (i.e. functions not built into Excel). The problem is that, up to a while ago, the last item in the dropdown list was (the Dutch equivalent of) "More functions...". Selecting this would open the Paste Function dialog (the dialog you open with Insert/Function... or with the fx button on the toolbar). Recently, this "More functions..." item has disappeared. I was wondering if anybody knows how to restore it.

    Regards,
    Hans

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: More functions missing (Excel 97 SR2 (Dutch))

    I do not have an answer, but since you are not getting answers thought I would respond. Both the XL 97and XL '00 I use show "More Functions ..." at the bottom of the drop down, and while I don't think the other post was exactly the answer, I wonder if you have an add-in which may be overriding/hiding it. If you have a bunch of add-ins, try disabling them one by one and see if it makes a difference.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: More functions missing (Excel 97 SR2 (Dutch))

    Hello John,

    The only add-in I had loaded was the Analysis ToolPak. I've disabled it and re-started Excel, but to no avail. Still no "More functions..." item at the bottom of the dropdown list.

    Thanks for the suggestion though.

    Regards,
    Hans

Posting Permissions

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