Problems w/Excel and Add-Ins

[Drew]

I have just installed the add-ins from the Value Pack in an effort to do
some date calculations on a spreadsheet.

When I have the spreadsheet open and then choose the Analysis ToolPak
from the Tools menu, the program quits immediately upon hitting OK to
activate the ToolPak. This happens every time on several different
worksheets...

Thoughts?

 

[Corentin Cras-Méneur [MVP]]

I have just installed the add-ins from the Value Pack in an effort to do
some date calculations on a spreadsheet.

When I have the spreadsheet open and then choose the Analysis ToolPak
from the Tools menu, the program quits immediately upon hitting OK to
activate the ToolPak. This happens every time on several different
worksheets...

Try deleting ~/Library/Preferences/Microsoft/Carbon registration
Database (~/ being your user folder) and relaunch Excel. THis often
helps.

If you have your user folder on a different partition than the boot
volume, then you'll have to start Office from a user account on the boot
volume to let it create this file, and then place a cpoy of this file in
the same location on your user fodler. This will fool Excel into
believing your user folder is on the boot volume.


Corentin

 

[Drew]

Try deleting ~/Library/Preferences/Microsoft/Carbon registration
Database (~/ being your user folder) and relaunch Excel. THis often
helps.

No joy...but I launched the Add-In directly from the Add-Ins folder, and
I didn't get the crash. But I still want to know what causes it in the
first place...

If you have your user folder on a different partition than the boot
volume, then you'll have to start Office from a user account on the boot
volume to let it create this file, and then place a cpoy of this file in
the same location on your user fodler. This will fool Excel into
believing your user folder is on the boot volume.

All my files are on the boot volume, so this one is N/A...

Thanks...

 

[Corentin Cras-Méneur [MVP]]

No joy...but I launched the Add-In directly from the Add-Ins folder, and
I didn't get the crash. But I still want to know what causes it in the
first place...

In this case, I don't know :-\
(bit I'm glad you got it to work).


Corentin