Add-in and automation functions
These functions call add-ins, external code or services. They depend on setup outside the workbook and are rarely used day to day.
5 functions in this category.
Start here
- COPILOT
Asks an AI model to classify, summarise, or generate text from cell data.
- PY
Runs Python code in the workbook through Python in Excel, with ranges passed in via xl().
- CALL
Runs a routine in a DLL or code resource from an old-style macro sheet; rarely used today.
- EUROCONVERT
Converts between the euro and currencies that joined it, using the official fixed rates.
- REGISTER.ID
Registers an external routine so that CALL can run it; a legacy macro-sheet function.
All add-in and automation functions
| Function | What it does | Level | Since | Spills? |
|---|---|---|---|---|
CALL | Runs a routine in a DLL or code resource from an old-style macro sheet; rarely used today. | Expert | 2007 or earlier | No |
COPILOT | Asks an AI model to classify, summarise, or generate text from cell data. | Advanced | 365 only | Yes |
EUROCONVERT | Converts between the euro and currencies that joined it, using the official fixed rates. | Expert | add-in | No |
PY | Runs Python code in the workbook through Python in Excel, with ranges passed in via xl(). | Advanced | 365 only | No |
REGISTER.ID | Registers an external routine so that CALL can run it; a legacy macro-sheet function. | Expert | 2007 or earlier | No |
Other categories
- Lookup and reference functions
43 functions
- Math and trig functions
80 functions
- Logical functions
19 functions
- Text functions
48 functions
- Date and time functions
25 functions
- Statistical functions
111 functions
- Financial functions
56 functions
- Information functions
21 functions
- Database functions
12 functions
- Engineering functions
54 functions
- Web functions
3 functions
- Compatibility functions
41 functions
- Cube functions
7 functions