Excel 2004 for Mac Solution Center

Formulas

Description of formulas to count the occurrences of text, characters, and words in Excel
Provides examples to describe formulas that calculate the number of occurrences of text, characters, and words.
How to create a dynamic defined range in an Excel worksheet
Provides a method to create a dynamic defined range that can automatically extend to include new information if you have a named range that must be extended.
Excel statistical functions: VAR and VARP improvements and data consolidation
Describes how Excel 2003 and later versions of Excel calculate the statistical functions VAR and VARP more accurately than earlier versions of Excel.

Description of the Microsoft Office 2004 for Mac 11.1.1 Update
Discusses the Microsoft Office 2004 for Mac 11.1.1 Update. This update addresses several issues with Microsoft Excel 2004 for Mac, PowerPoint 2004 for Mac, and Visual Basic for Applications in Office 2004 for Mac.
Description of Microsoft Office 2004 for Mac Service Pack 2 (11.2.0)
Describes Microsoft Office 2004 for Mac Service Pack 2 (11.2.0). This service pack addresses several security and stability issues in Office 2004 for Mac programs.

Calculated column returns #NAME? error when column headings are used in formula in Excel for Mac
When you use column heading names in the formula for a calculated column using the List feature, the cells in the calculated column may display the following error message and the formula is not calculated.
No calculation occurs when an array formula includes a large range in Excel for Mac
When you use an array formula based on a very large range (For example, over 25 columns and 1,000 rows), Microsoft Excel for Mac does not return a result. The cells do not appear to calculate and the status bar displays "Calculating Cells 0%."...
Dates and times displayed as serial numbers when viewing formulas in Excel
Microsoft Excel displays serial number values for dates and times in cells, but shows formatted dates and times in the formula bar.