My function doesn’t work

Cause: CUBE functions don't work in Excel for Mac.

Solution:    Open the workbook in a different version of Excel.

Excel 2007 and Excel 2003 can perform the following CUBE functions: CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, and CUBEVALUE.

Cause: The BAHTTEXT function doesn't work in Excel for Mac.

Solution:    Prevent sheet calculation errors by converting cells that contain the BAHTTEXT function to values.

Excel for Windows uses the BAHTTEXT function to convert a number to Thai text and add a suffix of "Baht." Excel for Mac can open and display sheets that are created in Excel for Windows and that contain BAHTTEXT. But if you recalculate such a sheet in Excel for Mac, any cells that contain BAHTTEXT display the #NAME! error value. To prevent Excel from recalculating a cell that contains BAHTTEXT, copy the cell and then paste it back into place as a value by using the Paste Special command on the Edit menu. After you do this, the cell does not recalculate with the rest of the workbook.

Cause: The CALL, REGISTER.ID, RTD, and SQL.REQUEST functions don't work in Excel for Mac.

Solution:    Open the workbook in a different version of Excel.

Versions of Excel for Windows can perform the CALL, REGISTER.ID, RTD, and SQL.REQUEST functions.

Solution:    Use Microsoft Query to connect to and query a SQL database.

For more information, see Import data from a database.

Cause: The EUROCONVERT function doesn't work in some versions of Excel for Mac.

Solution:    Open the workbook in a different version of Excel.

Excel 2004 for Mac can perform the EUROCONVERT function.

Solution:    Change the currency symbol to the euro sign (€).

For more information, see Change the currency symbol.

See also

List of all functions (by category)

 
 
Applies to:
Excel for Mac 2011