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.
No comments:
Post a Comment