Microsoft KB Archive/87243

{|
 * width="100%"|

Excel 4.0: Command+Option+E Gives &quot;Invalid Database&quot; Error

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
In Microsoft Excel 4.0 of the Macintosh, when you install the Crosstab ReportWizard to version 4.0 of Microsoft Excel for the Macintosh, and you press COMMAND+OPTION+E (or CONTROL+E on an enhanced keyboard), Microsoft Excel will attempt to start the Crosstab ReportWizard, and you will receive one of the following error messages:

If a database is not defined, the following error message will appear:

Invalid Database or Database not open.

If a database has been defined, the following message appears:

Invalid Argument.

Also, if COMMAND+OPTION+E is assigned to a command macro, you will not be able to run the macro with the key command when the Crosstab add-in is loaded.

WORKAROUNDS
To work around this problem, do either of the following:


 * Use another letter for the command macro.

-or-
 * Do the following to remove the Crosstab ReportWizard from the Add-In Manager Startup list so that the Crosstab ReportWizard is not loaded or installed with the Add-In Manager:


 * From the Options menu, choose Add-Ins.
 * Select the Crosstab ReportWizard.
 * Choose Remove.
 * Choose the OK button to confirm your choice.
 * Choose the Close button.