A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
The answer by Marcin Policht may be wrong. I had this same error and went through a TON of things trying to fix it. It took several days, but I finally found the simplest fix for it. Hopefully it also works for you.
The Compile error in hidden module cpInterview was misleading in my case because it reports as a compile error rather than an access-denied error. The fix for me ended up being to go to the Trust Center Settings in Excel and change the ActiveX Settings from "Disable all controls without notification" to "Prompt me before enabling Unsafe for Initialization (UFI) controls with additional restrictions for Safe for Initialization (SFI) controls with minimal restrictions."
The Trust Center can be found from going to File > Options, or if you have the Developer Tab enabled you can go there and click Macro Security. You can enable the Developer tab by going to File > Options > Customize Ribbon and then checking the box for the Developer Tab on the right column.