View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Mantithesis Mantithesis is offline
external usenet poster
 
Posts: 6
Default Analysis ToolPak won't display properly in Excel 2007

Jim,

I tried that, and it gave me an error that said Excel found unreadable
content and asked if I wanted to recover the contents of the workbook. I
clikced Yes and it said it removed part /xl/vbaProject.bin part. (VBA). It
did not get the Analysis group to show.

However, if I open FUNCRES.XLAM also, it will display the Analysis tab and
the Data Analysis icon. But the icon is dead, it does nothing. I have tried
many, many variations of this (opening other combinations of files in the
Library) and I can only get this close. Once I close Excel, all this is lost
and I have to start over when I reopen. Similarly, I can get Solver to show
like this, but it is a dead icon also.

The error mentioned above is too high level for me. Is it meaningful to you?
Seems like we're close, but somethig is still wrong.

Sorry for the delay. This problem is like a thorn in my side that I couldn't
let go of, and I've spent hours trying to solve. I decided earlier in the
week to let it go, and I missed the email notifying me that you had posted.
I'd really appreciate another reply if the error is meaningful.

Thanks for your time,
--
Mantithesis


"Jim Rech" wrote:

Would you try this and see what happens? First in Excel 2007 unselect all
add-ins. Then do a File, Open and manually open ATPVBAEN.XLAM (or the local
name if you're not using an English version) in the
\Office12\Library\Analysis folder under your Office 2007 installation.

Opening this file should open the ATP features and automatically open
FUNCRES.XLAM which has the ribbonx in it that creates the Data Analysis
group on the Data tab. I would think there is no way you could open this
file and not get the Data Analysis group on your Data tab. I say that
because I don't think there is a way to block ribbonx from loading when it
is in a file.

--
Jim
"Mantithesis" wrote in message
...
|I had a couple weeks ago, but I tried it again anyway. It found 2 things to
| fix. But it didn't fix this.
|
| --
| Mantithesis
|
|
| "Ron de Bruin" wrote:
|
| Btw: Have you try this in 2007
|
| Run Office Diagnostics.
| Office ButtonExcel Options...Resources
|
| Close and reopen Excel
|
|
| --
|
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
|
|
| "Ron de Bruin" wrote in message
...
| Hi Mantithesis
|
| Is it possible that the add-in simply won't work with both versions
installed?
|
| I have both versions on my laptop and have no problem when I install
the add-in
| in both versions
|
| --
|
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
|
|
| "Mantithesis" wrote in message
...
| I have installed Excel 2007 on my work laptop (Windows XP), but have
kept all
| Office 2003 products. When I install and activate the add-in for
Analysis
| Toolpak, it shows as installed in Excel Options -- Add-Ins, but the
Data
| Analysis group does not display under the Data tab.
|
| I am running Office 2007 on my home PC (Windows Vista) and it all
works fine
| there. I am confident that I know how to install and activate the
add-ins for
| Excel 2007. I think the problem is a result of still having the older
version
| of Excel still installed, which is necessary for work. I need Excel
2007 on
| my laptop for a Stats class. The add-in works fine in Excel 2003.
|
| I have found multiple mentions of this problem, but none with a
proposed
| solution. Example:
|
http://groups.google.com/group/micro...67c9e322c9acb0
|
| Is it possible that the add-in simply won't work with both versions
installed?
|
|
|