Make a Python function available in Calc, run it against the open spreadsheet, and troubleshoot missing macros or imports ...
Though this script can be used for any folder, my Downloads folder was an absolute nightmare. There were tons of screenshots, invoices, installers, and random documents all piled up in one place.