COPILOT

The COPILOT function returns the response based on your referenced data using an AI model.

link - techcommunity.microsoft.com/blog/microsoft365insiderblog/bring-ai-to-your-formulas-with-the-copilot-function-in-excel/4443487 
link - techcommunity.microsoft.com/blog/excelblog/introducing-formula-completion---a-new-way-to-write-formulas-in-excel-using-copi/4452196 
link - support.microsoft.com/en-gb/office/get-started-with-copilot-in-excel-d7110502-0334-4b4f-a175-a73abdfc118a 
link - support.microsoft.com/en-gb/office/turn-off-copilot-in-microsoft-365-apps-bc7e530b-152d-4123-8e78-edc06f8b85f1

Remarks

You can calculate up to 100 function calls every 10 minutes.

Common Errors

Error text	Error type	Description
Short-Term Limit Exceeded	#CONNECT	You have exceeded the limit of 100 Copilot function calculations within 10 minutes. Wait 10 minutes and try again.
Prompt Error	#VALUE	Your prompt cannot be evaluated. Edit your prompt and try again.
Prompt Too Large	#VALUE	Your prompt (including context) is too large. Please reduce the size of your prompt or context.
License Not Found	#BLOCKED	Your Copilot license could not be found. If you have a Copilot license try logging in again.
Server Timeout	#CONNECT	No response from the server. This may be resolved by simplifying your prompt, or there may be an issue with the server.
Confidential Workbook	#BLOCKED	The COPILOT function cannot calculate in workbooks labelled Confidential or Highly Confidential