A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.