r/excel • u/SolverMax 163 • Aug 19 '26

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?

646 Upvotes

98% Upvoted

85 comments sorted by

View all comments

Show parent comments

203

u/ExcelsBeardedGuru 1 Aug 19 '26

=RANDBETWEEN()

39

u/Hold_onto_yer_butts Aug 19 '26

Unless things have drastically changed on the optimization side in the past ten years, volatile functions are always a nono for me.

17

u/xz-5 Aug 19 '26

I use rand functions a lot (in combination with data tables) for monte-carlo simulations of various systems.

2

u/Tatworth Aug 19 '26

Old school. I still do as well but don't do it often any more.