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. |
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 (€). |
