Compile Error in Hidden Module: Distmon in Excel 2003 and 2007

If you have installed Excel 2003/2007 and Adobe Professional 7, 8 or 9, you may get the following error when you start Excel 2003 or Excel 2007:

"Compile Error in Hidden Module: Distmon"

Cause:
The cause of this error is PDFMaker.xla, which loads at startup.

Solution: 
The easiest solution is to delete PDFMaker.xla from your computer. Since Adobe Professional 8 uses DLL-addins to add the toolbar in Excel, you can safely delete the PDFMaker.xla file on your computer.

PDFMaker.xla may be at one or more locations on your computers.
Typically, PDFMaker.xla is stored in your profile directory:
C:\Documents and Settings\<user>\Application Data\Microsoft\Excel\XLSTART\PDFMaker.xla
In other scenarios, PDFMaker.xla is stored in your Program Files directory.

After you deleted the file PDFMaker.xla, the error "Compile Error in Hidden Module: Distmon" at startup of Excel shouldn’t appear. To be sure you delete all PDFMaker.xla files, you can search your C:\ drive for all PDFMaker.xla. Make sure you search in subfolders and hidden files and folders.

The error described above has been occured in combination with the following applications:

  • Adobe Acrobat Professional 7
  • Adobe Acrobat Professional 8
  • Adobe Acrobat Professional 9
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007

Leave a Reply

65 Comments on "Compile Error in Hidden Module: Distmon in Excel 2003 and 2007"

Notify of
avatar
Sort by:   newest | oldest | most voted
Rahul
Guest

Thanx problem has been resolved

ali
Guest

thanks , muy bien,,

Sudhakar
Guest

Sir I didnt find any pdfmaker.xla file in my whole computer. please help me

sangeeta
Guest

I am not able to find PDF maker..plz help

megs
Guest

Works for me too ! Thanks

mike
Guest

Thanks so much for the proper fix.

Paul
Guest

this helped me. I seached my C: drive, found the PDFMaker.xla file, deleted it, and Excel 2003 works without the error messages at opening and closing. THANKS!

KBWood
Guest

After searching my entire hard drive I found and deleted 3 instances of this. Now everything works. This worked better than the IT guy – 4 hour of messing with the computer with no result, 20 minutes of my time and works.

Thank you very much

amit
Guest

please help me how to find pdfmaker.xls file so i can soul my problem……

hkaf
Guest

Thanks

Ra2d
Guest

It works well. Thanks for your help.

JL
Guest

It works. thanks a lot!

Mandi
Guest

Thanks so much for the help, i have been having this problem for so long, i didn’t think there was a way to fix it. I followed you instructions and it worked like a charm.

Thanks Heaps

James Taylor
Guest

Thank you. It worked perfectly and my problem is resolved. Thanks for all your help.

Danielle
Guest

Dude, you rock! I LOVE google/the www. Man, I could be a computer geek with what I learn online!!! Thanks!!!!

copperdevil
Guest

Thank you so much man, I done with it. thanks

narayan
Guest

Thanks excellent support

ram
Guest

I have been getting this error for a while but ignored assuming that one of the file’s got corrupted. Today, I searched in google for an answer ,it worked .Error get resolved.

Thanks
Ram

James C
Guest

Thanks. Works great now. I have Adobe Acrobat X Pro and I found the file in Program Files. Spent a lot of time checking out the Microshit Site and found nothing. Thanks again.

Semsem
Guest

I have similar error but it is known as M_Base not Distmon, any idea how to fix it?
The full messages says: “Compile error in hidden module: M_Base”

Donna Thompson
Guest

I deleted two different PDFMaker.xla files and all works great now. Thanks for the help – that message was so annoying.

Jesal
Guest

Thanks – did the trick :)

Rick Malamed
Guest

I found PDFMarker.xla in several locations on my c: drive. I deleted them all and now Excel 2010 is running without the annoying error. THANKS!

Irvin
Guest
You need to get rid of the .xla & .dot extensions. Excel looks at the last 3 letters, not the nam as a whole. Linda Reed: I have had this issue on several of the PC’s in our office and have resolved the problem following the advice above (thank you very much!). However, I have one PC that will not cooporate. I did the search for both types of files (*.xla and *.dot) and the return shows the files, BUT someone had already renamed the files (pdfmaker.xla to pdfmaker.old.xla and pdfmaker.dot to pdfmaker.old.dot). Anyone have any ideas on how I… Read more »
Irvin
Guest

Linda Reed: I have had this issue on several of the PC’s in our office and have resolved the problem following the advice above (thank you very much!). However, I have one PC that will not cooporate. I did the search for both types of files (*.xla and *.dot) and the return shows the files, BUT someone had already renamed the files (pdfmaker.xla to pdfmaker.old.xla and pdfmaker.dot to pdfmaker.old.dot). Anyone have any ideas on how I can fix this PC?Thanks  (Quote)

Linda Reed
Guest

I have had this issue on several of the PC’s in our office and have resolved the problem following the advice above (thank you very much!). However, I have one PC that will not cooporate. I did the search for both types of files (*.xla and *.dot) and the return shows the files, BUT someone had already renamed the files (pdfmaker.xla to pdfmaker.old.xla and pdfmaker.dot to pdfmaker.old.dot).

Anyone have any ideas on how I can fix this PC?

Thanks

Mike Bindman
Guest

Thanks for the info. Your advice worked like a charm. Went the the C:\ Drive, searched all files and folders (including hidden files) and removed all instances of the pdfmaker.xla. Once removed, I opened up Excel 2007 and the error was gone. Appreciate the assistance.

Rick Villa
Guest

Thanks for the help. Deleted pdfmaker.xla and all is right with the world.

nitesh verma
Guest

Go to this link for solution…..u r done in less than 5 mins::

http://support.microsoft.com/kb/307410

Patricia
Guest

The tip on searching hidden files was the kicker! I couldn’t understand why the fix wasn’t working. Thanks so much, Cinnamon!

Matthew Schow
Guest

That fix worked for me beautifully, thank you so much! And now my create PDF function doesn’t crash Excel when I use it, which was causing me problems as well.

griff
Guest

Worked a treat, got rid of both annoying messages & excel opens much faster… Cheers

Alan Trotter
Guest

Help – I followed your instructions and got rid of the “distMon” issue but now when I open a spreadsheet it appears blank until I click on a cell with data in it and then the whole sheet appears!
Also- when I close the file a blank Book1.xlt isopen behind it!
Please help!

Alan Trotter
Guest

Help – I followed your instructions and got rid of the “distMon” issue but now when I open a spreadsgeet it appears blank until I click on a cell withdatainnnnnit and then the whole sheet appear! Alo- when I cloeit aablank Book1.xlt isopen behind it
Please help

Cinnamon
Guest

Just a note: When performing your search, be sure to check in the hidden folders/file, too. First search found nothing until I checked that box…

Me
Guest

I deleted the PDFMaker.xla and no longer have the error; howver, I no longer can use editing tools, in particular the highlight tool, Adobe Acrobat Pro now.

Shyuan-Bai Yang
Guest

I found the PDFMaker.xla and deleted it.
Now my excel works okay now.
Thanks for the info.

Paul
Guest

Thanks for the tip. It cleared the problem up straight away. The file was in the program files directory which kind of makes sense.

Cheers

Basetty Srinivasulu
Guest

It works well. Thanks for your help.

vtyk
Guest

Thank you for your tip

Patrick
Guest

Julie, you probably just deleted a shortcut. The actual file is in your Program Files folder

Julie
Guest

Found the file here: c:\Documents and Settings\user\Recent
I deleted it but it did not solve my problem. I still get the error message when I open AND close Excel.

Lisa
Guest

Found the PDFmaker.xla file and deleted it. Worked beautifully! Thank you for the info.

Donnie
Guest

Very useful information, Thanks a lot

nafees
Guest

thanks, it helped,and worked okay now..

nasiman
Guest

Great stuff.. thanks

Seko Addis
Guest

I used the windows search to locate and delete all the PDFMaker.xla files and it worked very well
Thanks!

ccinalb
Guest

Thank you! renaming the file in the profile settings did not work but deleting it did! go figure!

Scott
Guest

I find that removing most adobe products helps things go faster in all honesty.
~S

Zidanefan
Guest

Wonderful! Thank you! That was so annoying

KenP
Guest

After all else failed, I did a repair installation on Adobe 9, then did the search on the *.xla, *.dot, and *.xla.lnk, found the files, deleted them, and everything seems to still work fine.

Hope it helps.

jm4xs
Guest

thanks very much. finally someone was able to help me. neither Adobe nor Microsoft’s sites had a workable fix.

wpDiscuz