MS Office Excel 2019

Copper Contributor

I have just installed MS Office 2019.

When I open/close a workbook I get the following message:

 

Microsoft Visual Basic for Applications

Compile error in hidden module: Autoexec.

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. 

 

Clicking on OK clears the message with no detriment to the workbook.

How do I stop it from appearing ?

5 Replies
Check out which add-ins are installed in Excel, turn them off one-by-one to see which causes this.

@Jan Karel Pieterse Thank you for your reply, I have checked the add-ins for the workbook and find that there are no "Active Applications Add-ons" or "Document Related Add-ins".

The only entries are under "Inactive Application Add-ins"

I am in an area I don't fully understand have you any further advice ?

Likely. Open Excel options, click the addd-ins tab. Then close to the bottom use the drop-down and choose "Excel Add-ins" and click the Go button. Note the ones which are checked and uncheck them one-by-one, each time rebooting Excel to check if the error goes away. Repeat the above for "COM Add-ins" if you still have issues.
If that doesn't help, open WIndows explorer and type this into the address bar:
%appdata%\microsoft\excel\xlstart
and press enter. Move any files you see there to a temporary folder ands reboot Excel to see if the problem goes away. If not, open Excel, open File, Options and click the Advanced tab. Under the General section, check the box next to "Open all files in" and repeat the same for that folder (if any).
Hope you got the response by e-mail, it was a PDF maker file everything OK after I removed it.
Glad you were able to solve the issue!