While most people use the 32-bit version of Excel, there is an important community of users of the 64-bit version of Excel. A number of people have asked the question as to whether the Real Statistics Resource Pack works with the 64-bit version of Excel.
The following is an answer to this question based on the experiences of Paolo Piva, who is using the Real Statistics Resource Pack in Windows 10 (64 bit) using the 64-bit version of Excel 2016.
“I confirm that I use it under Windows 10 Pro 64 bits and that I installed it on Excel 64 bits, as part of Office 365 (which is Excel 2016).”
Paolo noted further that “when I closed Excel and then launched it again, the add-in menu with Real Statistics did not show up in the ribbon… I had therefore to implement the suggestion Unblock the Add-in File as described in:
https://www.excelcampus.com/vba/add-in-ribbon-disappears/
Paolo added “just to make sure that things work properly and the Addins menu is displayed Excel must be run as an Administrator. If it is not run as an Administrator, the Addins menu will not be displayed but the Real Statistics package will still work and can be accessed with the usual” Ctrl-m key sequence.
I’ve installed the Real Statistics following your instructions. It didn’t work. When I run the add-in this is what it says: “Compile error in hidden module: Analysis. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click “Help” for information on how to correct this error”
P.S. I am using 64-bit excel 2013 on Windows 8
Tim,
I have two suggestions.
1. Look at Hint 2 on the following webpage:
https://real-statistics.com/appendix/faqs/disappearing-addins-ribbon/
2. make sure that Solver is installed. You can check this by pressing Alt-TI and making sure that Solver appears on the list of addins with a check mark next to it.
I hope this helps.
Charles