Compile error in hidden module: This workbook.

Anonymous
2010-08-19T09:56:57+00:00

I've got the following error after installing office 2010. It's only shown once I want to open/close the Excel:

Microsoft Visual Basic for Applications:

Compile error in hidden module: This workbook.

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2012-04-23T16:52:38+00:00

After searching for answers to this problem repeatedly I finally came up with this...if anyone besides me is still having this problem, hopefully this will help.

Excel shows a "compile error in hidden module: thisworkbook" when opened or closed.

This error occurs because 2 excel files are corrupted.

To stop the error from occurring:

If in Windows XP open the following folder:

C:\Documents and Settings\USERNAME\Application Data\Microsoft\Forms     where USERNAME is the current user

If in Windows 7 open the following folder:

C:\Users\USERNAME\AppData\Roaming\Microsoft\Forms     where USERNAME is the current user

Once the folder is located, delete these 2 files

ComctlLib.exd

MSComctlLib.exd

Excel should now open without the error message.

Note: Excel will create 2 new files (with the same names) in the folder, but they will not be corrupted.

Was this answer helpful?

200+ people found this answer helpful.
0 comments

58 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2013-06-28T17:52:29+00:00

    After searching for answers to this problem repeatedly I finally came up with this...if anyone besides me is still having this problem, hopefully this will help.

     

    Excel shows a "compile error in hidden module: thisworkbook" when opened or closed.

    This error occurs because 2 excel files are corrupted.

    To stop the error from occurring:

    If in Windows XP open the following folder:

    C:\Documents and Settings\USERNAME\Application Data\Microsoft\Forms     where USERNAME is the current user

    If in Windows 7 open the following folder:

    C:\Users\USERNAME\AppData\Roaming\Microsoft\Forms     where USERNAME is the current user

    Once the folder is located, delete these 2 files

    ComctlLib.exd

    MSComctlLib.exd

    Excel should now open without the error message.

    Note: Excel will create 2 new files (with the same names) in the folder, but they will not be corrupted.

    There are no files that exist with the ones you've mentioned, ComctlLib.exd and MSComctlLib.exd... The user is using XP and still has this issue... Add-ins have been disabled and still have issues...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-02-22T15:07:51+00:00

    i ran a diagnostic on microsoft office it worked

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-01-27T22:22:16+00:00

    I solved this problem by deleting at windows xp     all files in this folder :

    C:\Documents and Settings\USERNAME\Application Data\Microsoft\Exce\XLSTART

    (where USERNAME is the current user)

    P.S Application Data folder is not visible...

    To Do visible this folder just open a folder. Go to Tools.. Go to Folder Options. Go to View... and MARK Show hidden files, folders and drives....

    I suppose if someone use Windows 7  should go to find again XLSTART folder.... at USERS folder....

    C:\Users\USERNAME\AppData\Roaming\Microsoft\Exce\XLSTART

    (where USERNAME is the current user)

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-01-16T13:47:33+00:00

    This did not work for me nor did the Microsoft fixit either and I still have the same problem with both word and exel  " compile error in  This workbook or Autostart in word .

    Has anyone any other ideas. It is not a problem as such but very annoying

    Was this answer helpful?

    0 comments