This FAQ addresses the following error message:
“Compile error in hidden module: ‘xx’. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application”
The usual reason for getting this message is that Solver has not been installed. You can determine whether this is the case, by pressing Alt-TI in Windows (or selecting the Add-ins option from the Tools menu on the Mac) and seeing whether Solver is on the list of add-ins with a checkmark next to it.
Another possible reason for getting this message is that Real Statistics was not installed properly, especially if you attempt to use the software by double-clicking on the file containing the Real Statistics software. You should never click on this file. To install Real Statistics you should follow the installation instructions shown on the webpage from where you download the software.
If you inadvertently double-click on the Real Statistics file to install the software, you may need to uninstall the software and then reinstall it.
If you have eliminated both of the reasons described above, it is also possible that the data analysis tool that you selected failed to run successfully on your data. The Real Statistics program should catch these problems and not display such a strange message, but the software is not perfect and so this can occur, although hopefully, this is a relatively rare occurrence. If it does happen, please report the problem using the Comment facility so that we can take corrective action if there is a bug in the software.
Mac Users: For some reason, this problem seems to occur more often on the Mac. Also, the problem may occur even when it hadn’t occurred in the past, even when performing the very same actions. Here is a workaround suggested by Jonathan Janzen in April 2018.
1. Open a new Excel workbook and select Add-Ins from the Tools menu and uncheck RealStats
2. Next close any open Excel workbook (but don’t quit Excel) and then reopen any Excel workbook
3. Select Add-Ins from the Tools menu and then check RealStats.
Now, when I tried to use the data analysis tool, it worked fine.
Reference
CFI (2021) Types of errors in VBA for Excel
https://corporatefinanceinstitute.com/resources/excel/study/types-of-errors-in-vba-for-excel/