To set up automatic triggers in Excel, the file must be saved first to a drive and additional permissions should be granted to that drive.
But if you keep seeing the message below when trying to save the file:
Please click the 'Open drive' link in the side bar and check which OneDrive location it opens. It should match with the logged in user's drive in the sidebar.
But if it opens a different drive location than the logged in user's drive or if you don't have permission to save the file to the opened OneDrive location, it means that the triggers are not authorised with the current license user. Please contact support to revoke any previous authorisations.