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



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language