Share via

How do I obtain Funcres.xlam?

Anonymous
2017-09-05T14:28:44+00:00

Split from this thread.

Then could either of you share the secret of accessing "FUNCRES.XLAM"? If that's an existing file, it doesn't appear to exist anywhere on my HD.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2017-09-05T18:42:35+00:00

    It seems unlikely that reinstall would be necessary. Here are the steps I followed:

    Make sure you have the "Solver" and "Analysis Toolpack" Excel Extras enabled. I'm not sure why, but it seems to be necessary to make FUNCRES.XLAM visible in the VBA Editor.

    Choose "Excel Add-ins" from the "Tools" menu. In the dialog that opens, make sure both are checked.

    Next, pull down the "Tools" menu and choose "Visual Basic Editor" from the "Macros" submenu. In the Visual Basic Editor window that opens, click the disclosure triangle if necessary to the left of "VBAProject (FUNCRES.XLAM)" to open it up. Click the disclosure triangle if necessary to open up "Modules." Select "RibbonX_Code."

    Click at the bottom of the right panel to make a text cursor active at the bottom of the existing text. Paste in the code lines from the above replies. (Following the examples that are already there, I typed in above the new code "'Paste Values", so I would remember what it does if I ever have to revisit this window.) Click the "Run" button at the bottom of the text entry area.

    Now, from the "Excel" menu, choose "Preferences". In the Preferences window, click on "Ribbon and Toolbar". Click on the "Quick Access Toolbar " tab. From the menu on the left labeled, "Choose commands from:," choose "Commands Not in the Ribbon." From this list, choose the newly-available "Paste Values" command (I don't have Excel in front of me, but I think the command was actually labeled something like "PasteVal"), and click the right-facing arrow to add the command to the Quick Access Toolbar at the very top of the Excel window.

    5 people found this answer helpful.
    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-09-06T20:17:55+00:00

    Hi M.Cox,

    Have you tried the David's steps above? Please let us know if you have any update.

    Regards,

    Tisky

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-09-13T21:26:49+00:00

    Apparently, an Excel update installed yesterday wiped out this addition to the RibbonX_Code. I had to add it back in today because it went missing.

    —Update: could it be that this get wiped out when Excel is quit? After re-adding it and using it, I quit and relaunched Excel and it is gone again.

    GRRR!

    1 person found this answer helpful.
    0 comments No comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  4. Anonymous
    2017-09-05T18:01:33+00:00

    Hi M.Cox,

    If you can't find the FUNCRES.XLAM on your Mac, we suggest you reinstall the Excel then check whether you can find the folder. Please follow the steps below:

    1. Open Finder > Applications.

    1. Right click Excel then click Move to Trash.
    2. Open Library > Containers, right click com.microsoft.Excel then Move to Trash.
    3. Go to Update history for Office 2016 for Mac to download the latest version of Excel.

    Regards,

    Tisky

    0 comments No comments