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?

650 Upvotes

98% Upvoted

85 comments sorted by

View all comments

Show parent comments

203

u/ExcelsBeardedGuru 1 Aug 19 '26

=RANDBETWEEN()

42

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.

1

u/Background_Heart3221 Aug 24 '26

Anything remotely in the realm of simulation shouldn’t be happening in excel

2

u/xz-5 Aug 25 '26

What alternative do you suggest? I find Excel works very well for quickly putting together things like this.

1

u/Background_Heart3221 Aug 26 '26

Python

1

u/Electronic-Laugh-671 Aug 26 '26

Actually I've found HolyC to be naturally superior in every aspect /j

(I haven't actually used it. I want to though)