The following table lists all of the Excel functions that are not supported by the optimiser.
ABSREF | DBCS | GET.CELL | LOGEST | RSQ |
APP.TITLE | DDB | GET.DOCUMENT | LOGINV | SAVE.TOOLBAR |
ARGUMENT | ENABLE.TOOL | GET.WINDOW | LOGNORMDIST | SEARCHB |
ASC | END.IF | GET.WORKBOOK | MIDB | SKEW |
BETADIST | ERROR | GET.WORKSPACE | N | SLN |
BETAINV | EVALUATE | GETPIVOTDATA | NEGBINOMDIST | STEP |
BINOMDIST | EXEC | GOTO | NUMBERSTRING | STEYX |
CALL | EXPONDIST | GROWTH | PERMUT | SYD |
CELL | FDIST | HARMEAN | PHONETIC | TINV |
CHIDIST | FINDB | HYPGEOMDIST | PRESS.TOOL | TRIMMEAN |
CHIINV | FINV | INFO | PROB | TTEST |
CHITEST | FISHER | ISPMT | QUARTILE | TYPE |
CONFIDENCE | FISHERINV | KURT | REGISTER.ID | USDOLLAR |
CRITBINOM | FTEST | LAST.ERROR | RELREF | VDB |
DATEDIF | GAMMADIST | LEFTB | REPLACEB | WEIBULL |
DATESTRING | GAMMAINV | LENB | RETURN | WINDOW.TITLE |
DB | GAMMALN | LINEST | RIGHTB | ZTEST |