Fix start-up error: "Compile Error in Hidden Module: Procedures"

[SandyYork]

Whenever I start Excel, I get the above error message. I can click OK and I
get in, but it appears again upon exiting. Upon startup I also get a "can't
find file" message looking for file: "C:\Program Files\Microsoft
Office\Office11\Library\Analysis\Funcres.xla" This all started when I tried
unsuccessfully to load add-ins. I've uninstalled and reinstalled MS Office
but these errors continue.

 

[Bill Manville]

The file you mention is part of the Analysis toolpak.
Either remove the analysis toolpak from your selected add-ins and/or
VBE references, or ensure that the analysis toolpak is installed.

The compile error will be in an add-in that you have installed.
Try de-installing each until you find the culprit

Bill Manville
MVP - Microsoft Excel, Oxford, England

 

[SandyYork]

Thank you for your response. I think this is a bigger problem, as I recently
installed a third-party add-in called "XLSTAT-Pro". Everything in Excel
under Tools/Add-ins is unchecked.

I have attempted to uninstall the third-party software by going to the
"Add/Remove Programs" option from the Control Panel, but the program is not
listed. I can see the program under C:\Program
Files\Addinsoft\XLSTAT\XLSTAT-Pro. In that folder there is an "Uninstall"
icon, but it doesn't work. It just opens the Excel program and returns the
same error message. When Excel opens, the worksheet title shows up as
"AutoExec" and the title in the blue title bar at the top is: "Microsoft
Excel - AutoExec.bas"

I've tried unsinstalling and reinstalling the entire Office program but it
did not resolve the problem. I may just have to try to do a system restore
to a date prior to loading this add-in. That will be my last resort. If
you could give me any further guidance, I would be very appreciative. Thank
you.

Sandy

 

[Bill Manville]

XLSTAT may have installed a file in your XLSTART directory (there are a
number of locations for such a directory, the contents of which are
automatically opened when you run Excel normally).

The most likely is in C:\Program Files\Microsoft Office\Office<nn>

Bill Manville
MVP - Microsoft Excel, Oxford, England