Excel 2004 for Mac Solution Center

Troubleshooting - Excel 2004 for Mac

• The yen character appears as a backslash in Excel 2004 for Mac when you open an Excel for Windows workbook
  Discusses a problem that occurs where the yen symbol appears as a backslash character in an Excel 2004 for Mac workbook.
• "am/pm" changed to "AM/PM" in custom number format in Excel for Mac
  If you open a workbook created in an earlier version of Microsoft Excel, and the workbook contains time data, the formatting for time data in cells or in charts may be changed from "am/pm" to "AM/PM". For example, if you create the time "1:00 am"...
• Help button is missing in VBA macro message box in Office for Mac
  If you run Microsoft Visual Basic for Applications (VBA) code by using the MsgBox function with code to display a Help button, the button does not appear in the message box.
• Stop Recording Toolbar is not displayed when you record a macro
  This article describes how the Stop Recording toolbar can fail to display when you record a macro.
• #N/A chart data labels may appear in wrong location in Excel for Mac
  In some column charts and bar charts, the data label for an #N/A value may be located improperly. If the #N/A label applies to the first data point, it may appear in the upper-left corner of the chart area. If it applies to a data point other than the...
• Find command doesn't work across Excel for Mac worksheets in group
  When you use the Find dialog box to locate specific information, Microsoft Excel for Mac only finds occurrences of the value on the active worksheet (even if you have selected multiple worksheets that contain this information). If the information is...
• Macro with Find method results in compile error in Excel for Mac
  When you run a Visual Basic for Applications macro in Microsoft Excel for Mac, you receive the following error message:
• How to create a column chart with two Y-axes in Excel
  Describes how to create a column chart with two Y-axes in Excel.
• Sorting alphanumeric text as numeric values
  In Microsoft Excel, a value formatted as a number will be sorted differently than a number formatted as text. Because of this difference, you may receive unexpected results when you mix numeric and text strings in a sort.
• Window options are not saved in a workspace file in Excel
  In Microsoft Excel, when you open a workspace file, all the workbooks in the workspace file have the following settings on the View tab of the Options dialog box: Window options Setting --------------------------------- Page breaks Clear Formulas Clear...
• "SYLK: File format is not valid" error message when you open a file in Excel for Mac
  When you try to open a text or comma separated variable (CSV) file, you receive the following error message: SYLK: File format is not valid This problem occurs when you open a text or CSV file and the first two characters of the file are the...
• Incorrect output is returned when you use the Linear Regression (LINEST) function in Excel
  Discusses a problem in which the incorrect output is returned when you use Linear Regression (LINEST) function in Excel.
• Text or number converted to unintended number format in Excel
  When you type a number in a cell, Microsoft Excel may automatically apply a built-in number format to the cell, based on the characteristics of the number.
• "File not loaded completely" error importing text files larger than 65536 rows in Mac XL
  If you open a text file in Microsoft Excel that contains more than 65536 rows, you may receive the following error message and the text file is truncated at row 65536.
• Not all characters appear in a worksheet cell in Excel for Mac
  When you type characters or enter a formula in a worksheet cell in Microsoft Excel, the number of characters that appear in the cell may be fewer than you expect.
• General number format applied to improper time entry in Excel for Mac
  In Microsoft Excel for Mac, when you enter a time into a cell, the cell may change to the General number format and display a decimal number.
• Resolving conflicts unhides previously hidden worksheet in Excel for Mac
  In Microsoft Excel, when you save a shared workbook and resolve conflicts in the workbook, worksheets that previously were hidden may become visible. This problem will occur if a conflict occurs on a hidden worksheet. If a conflict occurs on a...
• Description of the Microsoft Office 2004 for Mac 11.5.4 Update
  The Office 2004 for Mac 11.5.4 Update contains changes that improve security and performance. Additionally, this update includes fixes for vulnerabilities that can be used to overwrite the contents of a computer's memory by using malicious code.
• Formatting is not retained in PivotTable in Excel
  When you pivot fields or update data in a PivotTable, the formatting is cleared. This problem occurs if you update data or change the layout of the table when the following conditions are true: You click PivotTable on the PivotTable toolbar, point...
• Borders are printed black when "Black and White" is selected in the Page Setup dialog box in Excel for Mac
  When you print in Microsoft Excel, all borders are printed black regardless of the color you used to format them. For example, a border formatted with white is printed black. This problem occurs if the Black And White check box on the Sheet tab in...
• Error when sorting a range containing merged cells in Excel for Mac
  When you attempt to sort a range on a worksheet, you may receive the following message and Microsoft Excel does not sort the range.
• Unexpected behavior in Excel for Mac with numbers formatted as text
  If a number is formatted with the Text number format, and you attempt to change the format to something other than Text, the number may not be changed as you expect.
• ;;; number format fails to hide cell contents in Excel for Mac
  When you format a cell with the following number format ;;; the contents of the cell may still appear. This problem occurs when the cell contains more than 1,024 characters. To hide the contents of a cell that contains more than 1,024 characters,...
• "Invalid Picture" error message when you set the Picture property in Excel for Mac
  You may receive one of the following error messages when you try to set the Picture property of a user form: -or-
• "Not enough memory" error message when you add a chart to an Excel workbook
  When you attempt to add a new chart to a workbook or access the chart data source, you may receive the following error message: If you are using a Microsoft Visual Basic for Applications macro to add chart sheets to a workbook, you may also receive the...