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

[Jim Carlock]

The message is given when I try to close a workbook / kill
Microsoft Excel. I'm using Microsoft Excel 2002 / XP.

The spreadsheet includes a reference to another sheet that
someone else referenced in another message here.

I put the AddIn sheet in via:

Tools, AddIns..., Analysis ToolPack - VBA.

I've not referenced any function or procedure in the add-in.

I get a Triangular Warning / Error ? It's got a graphic of a Yellow
Triangle with an Exclamation Mark inside.

The subject is the exact text of the warning. A Microsoft Search on
the subject yielded nothing. Google yielded one page but and I
reviewed the page which targeted MacIntosh Excel 98 versions. I
am clearly using a different version.

I tried to go into the .XLA files but they seem to be password
protected (of which I did not password protect them). Is there
a way to unprotect the password protection?

Or has anyone else encountered this and is there a readily available
solution available?

Thanks much.

 

[Dave Peterson]

If you hit Alt-F11 when you're in excel, you'll be taken to the VBE. From
there, you can hit Ctrl-R to see the project explorer (like windows explorer).

You can expand each project (single click on each project and then hit the
asterisk key on the number pad to see all the components for each different
project).

If the workbook that refers to your other workbook is open, you'll see a branch
called "References". (You might have to open a few until you determine which
file has the reference.)

And once you find it, you'll have to decide if it's there for a reason or by
accident. If it's by accident, you can use an option on the toolbar called
Tools. Under that option is another called References.

Look for that referenced project's name and uncheck it.

====
the yellow exclamation points is a different subject. xl2002 has an option to
"help" you find things that it doesn't think are ok--like numbers stored as
text, formulas that aren't consistent.

You can see more of the options inside excel under tools|options|Error checking
tab.

 

[Jim Carlock]

If you hit Alt-F11 when you're in excel, you'll be taken to the VBE.
From there, you can hit Ctrl-R to see the project explorer
(like windows explorer).

You can expand each project (single click on each project and then
hit the asterisk key on the number pad to see all the components for
each different project).

When I am in VBE I see the references to two other items in the
Project Explorer. These two other items are:

* atpvbaen.xla
* funcres.xla

Oh there's a third: my Personal.XLS but that one is not part of the
problem.

When I hit the Asterisk or click on the + to try to look at what's in
the two xla files above, I'm prompted for a password. These two
files appearantly were installed when I clicked inside of Excel on:

* Tools
* then, AddIns...
* then, Analysis Toolpack - VBA

I can take the check mark out of the Analysis Toolpack and get
rid of the problem. I'm not even using it. I'm just wondering...
1) Is there a way to expand, open, view the .xla items ?
2) Is there a way to get to the password for those two items ?
3) Is this by design ? ( Because in my eyes, Microsoft has
provided a disfunctional item that doesn't work, and if there is
a fix available, I'm looking for it. ) I've only found one reference
to the problem when searching for it via Google and it was
listed as a Q181464 deal that only applies to MacIntosh
systems and this is definitely NOT a MacIntosh system. It also
applies to XL98. And I am using Excel 2002.

The file is a blank Book1.xls file. So it's completely useless to
me except in respect to the questions 1, 2, and 3 above.

Thanks for the reply, Dave.

 

[Dave Peterson]

Those .xla's are the analysis toolpak. The atpvbaen.xla is the VBA version and
the funcres.xla is the worksheet version.

I don't think you'd find anything interesting inside either of these even if you
had the passwords. But you don't want to break them either. They're important
components of excel.

(I've seen the password (for one of them??) posted in the newsgroups--but in my
opinion, it ain't worth the effort to google for them. (I looked when someone
posted it.))

I look at these things kind of the same as excel.exe. I can't read that
either. But if I could, all I could is either close without changing or make a
change and screw it up--both mean the same to me--keep my fingers out of them.

I guess you solved your problem. But I still have a question. Why is book1.xls
opening up? Especially if you don't need it????

It might be that it got stored into the XLStart folder. You might want to use
windows start button|find, and search for it. (to move it or kill it)

 

[Jim Carlock]

I guess you solved your problem. But I still have a question. Why is
book1.xls opening up? Especially if you don't need it????

It might be that it got stored into the XLStart folder. You might want to
use windows start button|find, and search for it. (to move it or kill it)

Book1.xls is the name of the file. I double click it in Windows Explorer
or open it via whatever manner happens to be convenient at the time.
It's the file I use when I want to mess with things and explore. So I was
reading a post that I think you might have posted about using the Analysis
Toolpack for certain things. I had a hard time finding it and because I
was having a hard time finding it I became fixated on finding it and
exploring it. I was going to post a message about the problems finding it,
because I was looking through References in the VBA IDE and it wasn't
there. I happened upon it accidently while exploring the Excel AddIn's. So
thus, we are here. I have this test workbook, that I double-click in
Explorer. It opens up. It currently has a couple functions in it here and
there, some named ranges, some VBA code, a button, a combobox
which I was looking for a handle to (hwnd), discovered that there are
no HWNDs for the controls in Excel, so then started to look for controls
from the VB/VC++ environments that I might perhaps reference. I
ended up giving up on that, as there are some other programming
issues that I needed to mess with, involving winsock, tcp/ip, udp, and
I ended up discovering that there's some source code out there that
connects to any and all major instant messaging services. The Excel
issues are really only a diversion for me at the moment while I'm
messing with TCP/Telnet/UDP and other such networking issues.

Got to have some kind of diversions to take me away sometimes.
;-)

I've set up some really nice spreadsheets that integrate with an
Access database on another project I'm working with.

I've seen Excel used in some really fascinating manners and I
have acquired an immense appreciation for it. So I've learned
some really great things by accident over the last month. And I'm
very much impressed by VBApp and the VB-IDE ( ? ) within
Excel.

I'm still a little perterbed that Microsoft decided to call VBApp
as Macro's and that you get to the VBApp IDE through Macro's.

A Macro is still what a Macro is to me based upon the
understanding I've acquired when using Macro's in Programmer's
Workbench and DOS style spreadsheets.

 

[Jim Carlock]

By the way... if I go into the VBE and dereference the two .xla items
in the Tools, References menu, the error that's presented in the
subject goes away.

If I disable the AddIn altogether the error goes away.

If I re-enable the AddIn, the References are NOT re-established
within the VBE Tools, References. It's only when I re-establish the
references there that the error message comes back.

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!

I guess you solved your problem. But I still have a question. Why is
book1.xls opening up? Especially if you don't need it????

It might be that it got stored into the XLStart folder. You might want to
use windows start button|find, and search for it. (to move it or kill

it)

Book1.xls is the name of the file. I double click it in Windows Explorer
or open it via whatever manner happens to be convenient at the time.
It's the file I use when I want to mess with things and explore. So I was
reading a post that I think you might have posted about using the Analysis
Toolpack for certain things. I had a hard time finding it and because I
was having a hard time finding it I became fixated on finding it and
exploring it. I was going to post a message about the problems finding it,
because I was looking through References in the VBA IDE and it wasn't
there. I happened upon it accidently while exploring the Excel AddIn's. So
thus, we are here. I have this test workbook, that I double-click in
Explorer. It opens up. It currently has a couple functions in it here and
there, some named ranges, some VBA code, a button, a combobox
which I was looking for a handle to (hwnd), discovered that there are
no HWNDs for the controls in Excel, so then started to look for controls
from the VB/VC++ environments that I might perhaps reference. I
ended up giving up on that, as there are some other programming
issues that I needed to mess with, involving winsock, tcp/ip, udp, and
I ended up discovering that there's some source code out there that
connects to any and all major instant messaging services. The Excel
issues are really only a diversion for me at the moment while I'm
messing with TCP/Telnet/UDP and other such networking issues.

Got to have some kind of diversions to take me away sometimes.
;-)

I've set up some really nice spreadsheets that integrate with an
Access database on another project I'm working with.

I've seen Excel used in some really fascinating manners and I
have acquired an immense appreciation for it. So I've learned
some really great things by accident over the last month. And I'm
very much impressed by VBApp and the VB-IDE ( ? ) within
Excel.

I'm still a little perterbed that Microsoft decided to call VBApp
as Macro's and that you get to the VBApp IDE through Macro's.

A Macro is still what a Macro is to me based upon the
understanding I've acquired when using Macro's in Programmer's
Workbench and DOS style spreadsheets.

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!

Those .xla's are the analysis toolpak. The atpvbaen.xla is the VBA version and
the funcres.xla is the worksheet version.

I don't think you'd find anything interesting inside either of these

even
if you

had the passwords. But you don't want to break them either. They're important
components of excel.

(I've seen the password (for one of them??) posted in the

newsgroups--but
in my

opinion, it ain't worth the effort to google for them. (I looked when someone
posted it.))

I look at these things kind of the same as excel.exe. I can't read that
either. But if I could, all I could is either close without changing

or
make a

 

[Dave Peterson]

The references within the VBE are usually used when you want to use one of the
functions within your code.

The stuff inside excel proper (tools|Addins) is used when you want to use a
function in the worksheet.

So changing tools|Addins won't affect the VBE references (for any/all
workbooks).

By the way... if I go into the VBE and dereference the two .xla items
in the Tools, References menu, the error that's presented in the
subject goes away.

If I disable the AddIn altogether the error goes away.

If I re-enable the AddIn, the References are NOT re-established
within the VBE Tools, References. It's only when I re-establish the
references there that the error message comes back.