There is a workbook that is trying to be closed that is being used by a workbook
that is still open. (I don't understand why you're getting it when you open
excel, though.)
Maybe you have a macro that is opening and closing a workbook for some
purpose????
If you try to close all the open workbooks, can you determine which workbook is
yelling at you?
If yes, then you can
open the VBE (hit alt-f11)
Show the project explorer (hit ctrl-r)
You're going to have to check each open workbook's project to see if has a
reference to that "unable to close" workbook.
Expand each workbook's project to show all the branches.
If this workbook has a reference to the troublesome workbook, you should see a
branch labeled "References"
Under that branch, you'll see the workbook that has
Then click on Tools|References
You should see something like:
Reference to book1.xls
Now look through the project once more. Look for book1.xls (or whatever it's
named) in the project explorer.
You should see something like:
VBAProject (Book1.xls)
or
ProjectNameHere (book1.xls)
if the project has been renamed.
Now make sure that your workbook with the reference to book1.xls is still
selected.
Tools|References|uncheck that project (VBAProject or ProjectNameHere) in that
list.
Be aware that there are some very good reasons for this reference to exist. If
you didn't create either workbook--the one with the reference or the one that
uses the reference, try to find the originator and ask if this is ok.
