I get the message “This workbook contains macros…”

Enable them! The spreadsheet needs them to function correctly!