If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error Message
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 |
#2
|
|||
|
|||
Error Message
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. Sheela wrote: 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 |
Thread Tools | |
Display Modes | |
|
|