Workbook reference error

[R Avery]

Using Excel XP.

I have an add-in that references Solver.xla. Unfortunately, whenever I
load up Excel, I get the following error while loading, and this prompt
is very annoying. How do I get rid of it but keep the reference to Solver?

Error:
This workbook is currently referenced by another workbook and cannot be
closed.


Any help would be most appreciated!

 

[Tom Ogilvy]

Depends on what is causing it. If you are unloading solver, then the
solution would be to check if it is loaded first, then don't unload and
reload it.

 

[R Avery]

I do not understand. My add-in does not call Solver on startup. It
merely contains a reference to Solver. I am not unloading or reloading
anything - just booting up Excel.

Any other suggestions? (Thanks!)

 

[Tom Ogilvy]

If you are not doing anything and you get the message, then you will have to
debug your environment to figure out what is causing the message. The
situation you describe is not what is normally experienced, so it is
something specific to your environment.