In your Excel file, on the desktop version, use the top toolbar and click either ‘Clear Data’ or ‘Get Report’, depending on what you need. After that, you’ll be prompted to grant permission so the script can run.
You need to allow this because the script interacts with your file—like modifying data or generating reports—and Excel requires your approval to make sure nothing runs without your consent. It’s a built-in security feature to protect your data.
This permission only needs to be granted once. After that, you won’t have to approve it again. The permission instructions are in your spreadsheet, on the ‘Instructions’ sheet.