cannot open message

[Peter]

Using Excel 2003 under WinXP Pro When opening Excel I keep getting a
message: cannot open Add_ in for editing, edit the source file instead. When
I uncheck the add in box and re open the message goes away. Does anyone have
any suggestions?
My installation on this machine was office 2000, then office XP and now
Office 2003.

TIA

 

[Dave Peterson]

Excel opens files in your XLStart folder and addins checked in Tools|addins. If
you isolate the addin having trouble, you could post back with more info.

In the meantime, you may want to read Chip Pearson's site for more things to
try:
http://www.cpearson.com/excel/StartupErrors.htm

====
It kind of sounds like you have the addin already open (or rather, excel thinks
it's already open. You may want to try closing excel, cleaning your windows
temp folder and rebooting your pc.

 

[Peter]

Thanks for the response. I should have posted what I tried, which included
not only your suggestion, but a complete boot time defrag. The analysis tool
pack is the one causing my problem. It may be that the funcres.xla What is
driving me nuts is that this is an intermittent problem. It seems that
Excel is trying to open funcress for editing. I was wondering if others may
be having this problem.

 

[Dave Peterson]

My next guess would be to delete the funcres.xla addin--use windows start
button|find to search for all of them and delete them all.

Then reinstall the analysis toolpak from the installation cd.

(But that's just a guess.)

Thanks for the response. I should have posted what I tried, which included
not only your suggestion, but a complete boot time defrag. The analysis tool
pack is the one causing my problem. It may be that the funcres.xla What is
driving me nuts is that this is an intermittent problem. It seems that
Excel is trying to open funcress for editing. I was wondering if others may
be having this problem.