Article ID: 905677 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft Excel 2004 for Mac and Microsoft Office Excel 2003 are similar in many ways. For example, the programs share a common file format and share most of the same features. However, there are some important differences that you should consider when you work with both Excel 2004 for Mac and Excel 2003.
This article contains general information about the difference between Excel 2004 for Mac and Excel 2003.
ActiveX controlsExcel 2004 for Mac does not support the use of ActiveX controls, also known as OCX files or OCXs. You cannot insert or use ActiveX controls in worksheets, in custom dialog boxes, or in custom UserForms.
Because ActiveX controls are not supported in Excel 2004 for Mac, the Control Toolbox toolbar is not available in Excel 2004 for Mac workbooks. Although the Toolbox in the Microsoft Visual Basic Editor is available, you cannot add ActiveX controls to the Toolbox in the Microsoft Visual Basic Editor.
If you use Excel 2004 for Mac to open an Excel 2003 workbook that contains one or more ActiveX controls, one of the following problems may occur:
The application "unknown" has unexpectedly quit, because an error of type 3 occurred.
Run-time error '57121': Can't exit design mode because Control 'CheckBox1' can not be created.
Run-time error '32809': Application-defined or object-defined error.
If you modify an Excel 2003 workbook that contains ActiveX controls, save the workbook, and then reopen the workbook in Excel 2003, the ActiveX controls work correctly. However, the ActiveX controls do not work correctly if you open the workbook in Excel 2004 for Mac. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Run-time error '1004': Cannot start the source application for this object. There may not be enough memory available.
(https://support.microsoft.com/kb/274222/ )Error when you paste ActiveX controls or run a macro in Excel for Mac
The 1904 date system and the 1900 date systemThe default date system in Excel 2004 for Mac is the 1904 date system. The default date system in Excel 2003 is the 1900 date system. Typically, the use of different date systems does not cause a problem.
However, if you transfer a workbook from Excel 2003 to Excel 2004 for Mac, or vice versa, and then copy a date from one workbook to the other, the date may increase or decrease by four years and one day. This issue occurs if the two workbooks use different date systems.
For example, if you copy the date 1/1/1998 from a workbook that uses the 1900 date system and then paste the date into a workbook that uses the 1904 date system, the date appears as 1/2/2002. Alternatively, if you copy the date 1/1/1998 from a workbook that uses the 1904 date system and then paste the date into a workbook that uses the 1900 date system, the date appears as 12/31/1993.
As long as you know about the date systems that your workbooks use, the different date systems should not cause a problem. For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/214330/ )Description of the differences between the 1900 date system and the 1904 date system in Excel
(https://support.microsoft.com/kb/274238/ )Date returned in a macro is four years too early
(https://support.microsoft.com/kb/274277/ )Chart axis may be four years early after you format scale in Excel for Mac
The Quattro Pro file formatExcel 2004 for Mac does not support the Quattro Pro file format. If you try to open a file that is saved in any Quattro Pro file format (WQ1, WQ2, WB1, or WB2), you receive the following error message:
If you must open a Quattro Pro file in Excel 2004 for Mac, use one of the following methods:
This file is not in a recognizable format.
Visual Basic EditorThe Visual Basic for Applications editing environment (the Visual Basic Editor) in Excel 2004 for Mac is similar to the Visual Basic Editor in Excel 2003. However, consider the following differences in the Visual Basic Editor in Excel 2004 for Mac:
ADO, DAO, and ODBCDirectActiveX Data Objects (ADO), Data Access Objects (DAO), and ODBCDirect are not available in Excel 2004 for Mac. Therefore, you cannot run VBA macros that use ADO, DAO, or ODBCDirect to import external data into Excel. However, you can run macros that use standard Open Database Connectivity (ODBC) to import external data.
Embedded objectsIn Excel 2003, if you insert a document from another program into an Excel worksheet, you can modify the embedded document by double-clicking it. When you do this, the document is edited in place. That is, you continue to work in Excel 2003, but the menus and the toolbars change to those of the other program so that you can modify the embedded document.
In-place editing is not available in Excel 2004 for Mac. If you double-click a document that is inserted in an Excel worksheet, the program for the embedded document starts separately. Then, you can modify the document in the other program. After you modify the document, you close the other program and then return to Excel 2004 for Mac.
TemplatesIf you want to modify a template in Excel 2003, you just open and then modify template. Any changes that you make to the template are saved when you save the template.
If you want to modify a template in Excel 2004 for Mac, you must hold down the SHIFT key when you open the template. After the template is open, release the SHIFT key. Then, you can modify and then save the template.
Menu barsThe steps to modify the Worksheet or Chart menu bar are slightly different in Excel 2004 for Mac than in Excel 2003. To modify the Worksheet or Chart menu bar in Excel for Mac 2004, follow these steps:
Menu iconsIn Excel 2004 for Mac, icons do not appear to the left of menu commands even though the icons appear when you customize menus, menu commands, and submenus. This behavior is by design.
For the latest Microsoft Knowledge Base articles and other support information about Excel 2004 for Mac, visit the following Microsoft Web site: