Tags: closed, excel, includes, kill, message, microsoft, msdn, referenced, software, spreadsheet, workbook

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

On Microsoft » Microsoft Excel

35,191 words with 6 Comments; publish: Thu, 22 May 2008 05:44:00 GMT; (306125.00, « »)

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.

--

Jim Carlock

http://www.microcosmotalk.com

Feel free to post back to the newsgroup!

All Comments

Leave a comment...

  • 6 Comments
    • 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 wrote:

      > 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.

      > --

      > Jim Carlock

      > http://www.microcosmotalk.com

      > Feel free to post back to the newsgroup!

      --

      Dave Peterson

      ec35720.excel.questionfor.info.msn.com

      #1; Thu, 22 May 2008 05:45:00 GMT
    • "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote in message

      news:3F64C141.56BA33B6.excel.questionfor.info.msn.com...

      > 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.

      --

      Jim Carlock

      http://www.microcosmotalk.com

      Feel free to post back to the newsgroup!

      > 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 wrote:

      > >

      > > 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.

      > >

      > > --

      > > Jim Carlock

      > > http://www.microcosmotalk.com

      > > Feel free to post back to the newsgroup!

      > --

      > Dave Peterson

      > ec35720.excel.questionfor.info.msn.com

      #2; Thu, 22 May 2008 05:46:00 GMT
    • 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 wrote:

      > "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote in message

      > news:3F64C141.56BA33B6.excel.questionfor.info.msn.com...

      > > 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.

      > --

      > Jim Carlock

      > http://www.microcosmotalk.com

      > Feel free to post back to the newsgroup!

      >

      Dave Peterson

      ec35720.excel.questionfor.info.msn.com

      #3; Thu, 22 May 2008 05:47:00 GMT
    • "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote:

      > 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

      > change and screw it up--both mean the same to me--keep my fingers out of

      them.

      >

      > Jim Carlock wrote:

      > >

      > > "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote in message

      > > news:3F64C141.56BA33B6.excel.questionfor.info.msn.com...

      > > > 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.

      > >

      > > --

      > > Jim Carlock

      > > http://www.microcosmotalk.com

      > > Feel free to post back to the newsgroup!

      > >

      >

      > --

      > Dave Peterson

      > ec35720.excel.questionfor.info.msn.com

      #4; Thu, 22 May 2008 05:48:00 GMT
    • 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!

      "Jim Carlock" <anony.excel.questionfor.info.localhost.com> wrote in message

      news:uczI31yeDHA.632.excel.questionfor.info.TK2MSFTNGP10.phx.gbl...

      > "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote:

      > > 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

      > > change and screw it up--both mean the same to me--keep my fingers out of

      > them.

      > >

      > >

      > > Jim Carlock wrote:

      > > >

      > > > "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote in message

      > > > news:3F64C141.56BA33B6.excel.questionfor.info.msn.com...

      > > > > 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.

      > > >

      > > > --

      > > > Jim Carlock

      > > > http://www.microcosmotalk.com

      > > > Feel free to post back to the newsgroup!

      > > >

      > >

      > >

      > > --

      > >

      > > Dave Peterson

      > > ec35720.excel.questionfor.info.msn.com

      >

      #5; Thu, 22 May 2008 05:50:00 GMT
    • 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).

      On the other hand, you have to load the atpvbaen.xls file so that your code can

      use it.

      Jim Carlock wrote:

      > 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!

      > "Jim Carlock" <anony.excel.questionfor.info.localhost.com> wrote in message

      > news:uczI31yeDHA.632.excel.questionfor.info.TK2MSFTNGP10.phx.gbl...

      > > "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote:

      > > > 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

      > > > change and screw it up--both mean the same to me--keep my fingers out of

      > > them.

      > > >

      > > >

      > > > Jim Carlock wrote:

      > > > >

      > > > > "Dave Peterson" <ec35720.excel.questionfor.info.msn.com> wrote in message

      > > > > news:3F64C141.56BA33B6.excel.questionfor.info.msn.com...

      > > > > > 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.

      > > > >

      > > > > --

      > > > > Jim Carlock

      > > > > http://www.microcosmotalk.com

      > > > > Feel free to post back to the newsgroup!

      > > > >

      > > >

      > > >

      > > > --

      > > >

      > > > Dave Peterson

      > > > ec35720.excel.questionfor.info.msn.com

      > >

      > >

      --

      Dave Peterson

      ec35720.excel.questionfor.info.msn.com

      #6; Thu, 22 May 2008 05:50:00 GMT