Error Message

[Sheela]

Hello,

When I open excel application, an error message will pop
up "This workbook is currently referenced by another
workbook and cannot be closed".

How do I remove this error message?

Thanks,
Sheela

 

[Dave Peterson]

One way to find the referenced file is to open excel and then hit alt-F11 to get
to the VBE (where macros live and references can be assigned).

Hit ctrl-R to see the project explorer. If you expand the projects (like
expanding folders in windows explorer), you can see "microsoft excel objects"
and for the projects that have references, you can see "References". If you
expand that, you'll see what workbook (and project) is being referenced.

Then if you decide that reference needs to be removed,
Tools|references and uncheck that workbook's project.