Often we see people claiming that "This new thing is the spreadsheet killer, like ai at the moment. People have been saying this forever but spreadsheets are still here. And there's a good reason for it.
AI sits at the "speed" corner. Excel, a fully dynamic interactive programming language with one type "cell", gives slightly better correctness and accountability. Coalescing process into program continues to move you to the other end. Once you start employing typechecking and later formal verification, you get more correctness and accountability - BUT at a cost of development time, AND generality. The correctness is achieved precisely by being tailored to the specifics and rejecting the general.
This can apply to entirely physical processes. Some "aerospace" grade parts are very similar to normal parts .. but with a huge overhead of accountability. Because getting the right outcome matters.
The only way AI has a chance of killing spreadsheets is if it replaces a Real Programmers, by becoming a tool that lets anyone interactively build arbitrary apps, for free (on the margin), with near zero turnaround.
That's likely not down to the tool, more likely a complex requirement you understand but they don't. (And are you sure you're getting the right answer? IIRC an analysis showed 10% of spreadsheets have errors - devs do care about good results, and that does take extra time)
> Where a programme solution is static and needs tons more hours for every change needed.
Hmm. Sounds like there's something wrong here, with your guys or some aspect of the business (and sure, excel is not a bad tool, just to be clear).