View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Workbook reference error

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.

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
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!