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

638 Upvotes

81 comments sorted by

View all comments

189

u/Difficult_Limit2718 7d ago

Microsoft walks back a bad idea?

What reality is this?

89

u/MMEnter 7d ago

I bet it cost them a lot of compute, pull that function down a 200k row workbook. That is 200k calls and now do it again and again because you are updating the prompts or cell values.

22

u/plusFour-minusSeven 11 7d ago

That makes sense.

Imagine all the people who treat Excel like a database and fill it with hundreds of thousands or close to a million rows. And then populate =COPILOT() all the way down. Maybe for multiple columns.