The first bug its tests caught was the AI's own.
Huge Excel sheets can be annoying, but they don't have to be.
Make a Python function available in Calc, run it against the open spreadsheet, and troubleshoot missing macros or imports ...