Make a Python function available in Calc, run it against the open spreadsheet, and troubleshoot missing macros or imports ...
Huge Excel sheets can be annoying, but they don't have to be.