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)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×