Microsoft KB Archive/312833

From BetaArchive Wiki
Knowledge Base


Excel crashes after you load the Analysis Toolpak - VBA add-in in Excel X for Mac

Article ID: 312833

Article Last Modified on 1/31/2007



APPLIES TO

  • Microsoft Excel X for Mac



This article was previously published under Q312833

SYMPTOMS

If you load the Analysis Toolpak - VBA add-in, Excel stops responding, and you receive the following error message:

The application Microsoft Excel has unexpectedly quit.
The system and other applications have not been affected.

CAUSE

The problem may occur when the following conditions are true:

  • You click Add-Ins on the Tools menu, click to select the Analysis Toolpak - VBA check box, and then click OK.
  • A workbook that contains data is open.


WORKAROUND

To turn on the Analysis Tookpak - VBA add-in, follow these steps:

  1. Start Excel, and click OK to create a blank workbook.
  2. On the Tools menu, click Add-Ins.
  3. Click to select the Analysis Toolpak - VBA check box.
  4. Click OK.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem does not occur in Microsoft Excel 2004.


Additional query words: MacXLX Mac XLX toolpack ATP XL value pack analyze tool pak install load open access OS X excel vba automate crash crashes crashing crashed quit quitting quits fail fails failing failed break

Keywords: kbbug kbpending KB312833