Excel 2004 for Mac Solution Center
how-to articles - Excel 2004 for Mac
- The document stops responding when opening in Word for Mac, in Excel for Mac, and in PowerPoint for Mac
Describes how to troubleshoot problems that occur when you open a file in Word, Excel and PowerPoint for the Macintosh.
- Office for Mac document or file opens slowly than expected
Describes how to troubleshoot documents that open slower than expected in Office for Mac.
- Trying to open .xlsx, .docx, or .pptx file in Office for Mac 2004: "This file is not in a recognizable format"
Describes how to obtain and install the Open XML File Format Converter for Mac. You must have this converter to open Office 2008 for Mac documents in an earlier version of Office for Mac.
- Floating-point arithmetic may give inaccurate results in Excel
Discusses that floating-point arithmetic may give inaccurate results in Excel.
- How to troubleshoot Office 2004 setup problems
This article describes how to troubleshoot Microsoft Office for Mac 2004 installation issues. The "More Information" section addresses the following topics: System requirements Permissions Damaged media Upgrade eligibility
- Excel statistical functions: TREND
Describes the TREND function in Excel 2003 and in later versions of Excel, illustrates how the function is used, and compares the results of the function in later versions of Excel with results of TREND in earlier versions of Microsoft Excel.
- How to restore a list to text in Excel 2004 for Mac
Describes how to restore a list to text in Excel 2004 for Mac.
- Error trapping with Visual Basic for Applications in Excel for Mac
When a run-time error occurs in a Microsoft Visual Basic for Applications macro, an error message appears on the screen, and the macro either halts or behaves unpredictably. To prevent the application from crashing or behaving unpredictably, you can...
- How to remove individual AutoFilter drop-down lists in Excel for Mac
In Microsoft Excel for Mac, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft Visual Basic for Applications. This article includes a sample Visual...
- Description of the differences between the 1900 date system and the 1904 date system in Excel
Provides the description of the differences between the 1900 date system and the 1904 date system in Excel. Discusses the problems that you may experience when you use these two different date systems in Excel workbooks.
- How to use macros to sort data in multiple columns as one column in Excel
Describes how to use macros to sort data in multiple columns as one column. Discusses how to use the sorting feature to sort a list in Excel. Contains a VBA example.
- How to create a Word for Mac merge document by using Excel data
This article explains how to create a simple data merge (mail merge) by using data that is stored in a Microsoft Excel workbook. By following these instructions, you can create a form letter (main document), select the Excel data document, and merge...
- How to copy or move sheets by using VBA code in Excel for Mac
You can use Microsoft Visual Basic for Applications (VBA) code to copy or move sheets within a workbook or between workbooks. This is particularly useful if you want to move or copy many sheets, or if you want to make multiple copies of a sheet. This...
- How to use the forms controls on a worksheet in Excel
Describes how to use several controls for dialog sheets to help you select data in Excel. This article also provides an example to show how to use this feature.
- How to display the file name of a worksheet without using a macro in Excel for Mac
This article describes how to create a formula that displays the file name of a worksheet in a cell. For example, for a file with the path :Users:local:Desktop, the formula returns :Users:local:Desktop:( )Sheet1 where is the name of your hard disk and...
- How to add a series to a chart in Excel for Mac
Describes how to add a series to a chart in Excel 2008 for Mac or Excel 2004 for Mac.
- Macros to delete formula links in Excel for Mac
When you open a workbook that contains links to another workbook, Microsoft Excel asks you if you want to update links. If the file that the link is referring to no longer exists, or if it has been moved to a different folder, you may want to delete...
- How to add templates from the Mactopia Web site to the Project Gallery in Office 2004 for Mac
This article describes how download and add templates on the Mactopia Web site to the Project Gallery in Office 2004 for Mac.
- Corrections to Help topics for taking screen shots in Excel 2004 for Mac
Describes corrections to Help topics for taking screen shots in Excel 2004 for Mac.
- How to use VbConstants in text strings in Excel for Mac
Microsoft Visual Basic for Applications includes a number of constants that you can use in code to represent certain "untypeable" characters, such as tabs, line feeds, and carriage returns. This article contains information about using these constants...
- How to combine cells of information in Excel
In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.
- Color option not available for header or footer text in Excel for Mac
This article describes which text formatting options are available in the header or footer. The formatting options are very basic, and font color is not one of the available options.
- How to create a Personal Macro Workbook in Excel for Mac
This article describes how to create a Personal Macro Workbook for writing and editing Microsoft Visual Basic for Applications (VBA) macros that you cannot record.
- How to move module code to another Excel for Mac workbook
This article describes how to move Microsoft Visual Basic for Applications (VBA) code from one workbook to another.
- How to customize or reset a menu in an Office for Mac program
This article describes how to perform the following menu customizations in the Macintosh versions of Microsoft Excel, of Microsoft PowerPoint, and of Microsoft Word: Create a menu. Change the name of a menu. Add commands to a menu. Remove a command...