• More functions missing (Excel 97 SR2 (Dutch))

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » More functions missing (Excel 97 SR2 (Dutch))

    Author
    Topic
    #373829

    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

    Viewing 0 reply threads
    Author
    Replies
    • #602395

      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/%5B/url%5D
      If you read French you won’t have a problem.

      Jim Cone
      San Jose, CA USA

      • #602768

        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

        • #602821

          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.

          • #602824

            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

    Viewing 0 reply threads
    Reply To: More functions missing (Excel 97 SR2 (Dutch))

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: