A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi @Jack Scales
The error message itself names the most likely cause: Excel on the web needs third-party cookies to load Office Scripts, and the desktop app doesn't use browser cookies at all. That's why your saved scripts work on desktop but not in the browser. Microsoft's Office Scripts troubleshooting guide lists third-party cookies as one of the checks when the Automate tab doesn't work on the web.
Since you're on a personal account, the admin part of that message doesn't apply to you. Here's what to change:
- Microsoft Edge: go to Settings > Cookies and site permissions > Manage and delete cookies and site data, and turn off Block third-party cookies.
- Google Chrome: go to Settings > Privacy and security > Third-party cookies, and select Allow third-party cookies.
- Safari on Mac: go to Settings > Privacy, and clear Prevent cross-site tracking.
- Close all browser windows, open Excel on the web again, and go back to the Automate tab.
If it works after that, you can switch cookies back to blocked and add the Office sites you use as exceptions instead, so the change isn't global.
One more thing to know: for personal and family Microsoft 365 subscriptions, Office Scripts is still in preview, and Microsoft lists joining the Microsoft 365 Insider program as a requirement. So some differences between desktop and web can come from the preview itself.
Which browser are you using, and do you have any privacy or ad-blocking extensions turned on?
If allowing third-party cookies brings your scripts back, please consider accepting it as the answer. If the same error still appears, let me know and I'll be happy to keep helping.
Reference: