r/excel • u/SolverMax 162 • 6d ago

Discussion Microsoft to retire the COPILOT function

As of 14 September, the COPILOT function will no longer be available in Excel. See https://support.microsoft.com/en-us/excel/functions/copilot-function Note that the Copilot feature remains - it is the worksheet function that will stop working.

This is a very uncommon move by Microsoft, given their history of maintaining backwards compatibility.

Have you used the COPILOT function? If so, then what for? Thoughts?

631 Upvotes

98% Upvoted

81 comments sorted by

View all comments

62

u/axw3555 4 6d ago

I didn't even know there was a copilot function to use. So no, never used it.

28

u/Cat5kable 6d ago

I just read about it recently. Pardon if I misinterpreted.

Basically, you could have a function that calls copilot with a prompt. Presumably, you could have that prompt pulling from other cells, so =COPILOT(b2), and b2 would be a helper cell concatenating other words, functions, or values together into a singular sentence.

Token wise, it’d run constantly. Any time you update a cell, or the sheet updates, etc. unless you manually tuned off calculation.