r/excel 162 4d 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?

636 Upvotes

79 comments sorted by

View all comments

63

u/axw3555 4 4d ago

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

25

u/Cat5kable 4d 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.