Special Functions

A small group of Microsoft Excel functions are not supported in Extreme speed: CALL, CELL, GETPIVOTDATA, INFO, HYPERLINK, REGISTER.ID, and the CUBE functions added in Microsoft Excel 2007 or later (CUBEMEMBER, CUBEVALUE, CUBESET, CUBESETCOUNT, CUBERANKEDMEMBER, CUBEMEMBERPROPERTY, CUBEKPIMEMBER). Any forecast formulas that contain one or more of these functions will be flagged as incompatible:

Example message: "Unsupported Microsoft Excel or Crystal Ball function at cell location [Book1.xls]Sheet1!A1. (Code #5539)"
Workaround: Avoid using these functions if you want to run the model in Extreme speed.