How to Fix Missing Automate Script Daily Schedule Option
Question details
The user is unable to find the option to schedule an Automate script to run on a daily basis.

- Product
- Microsoft Excel / Power Automate
- Device & OS
- not provided
- Scenario
- Attempting to configure a daily recurrence for an Automate script, but the scheduling feature is missing.
- Observed behavior
- The daily schedule option does not appear in the interface, despite being available when using a different account.
Verify that you are currently logged into the correct Microsoft account, as automation capabilities are tied directly to the specific licenses assigned to your profile.
Acquire or Verify Your Power Automate Subscription
Scheduling an Automate script requires a qualifying Power Automate subscription. If the option is missing, your current account lacks the necessary license.
Cloud-based Office Scripts rely on Microsoft Power Automate to run on a set time interval. While you can run standard scripts manually with a basic Microsoft 365 business license, configuring them to trigger automatically requires a premium Power Automate plan.
Log into your Microsoft 365 account portal and navigate to your account settings to view your active subscriptions.
If you do not see a 'Power Automate per-user plan' or an equivalent premium license, contact your organization's IT administrator to have the license assigned to your account.
Once properly licensed, open Power Automate, create a 'Scheduled cloud flow', set the recurrence frequency to 'Daily', and add the 'Run script' action for your Excel file.
Looking for a Free and Lightweight Office Suite?
If complex subscription tiers and missing premium features are slowing down your productivity, consider switching to WPS Office. It provides robust spreadsheet tools and extensive macro support without the burden of expensive recurring license fees.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
- 3. Open your spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to continue working seamlessly.

Frequently Asked Questions
Why was the scheduling option available on my other account but not this one?
Microsoft 365 features are granted on a per-account basis. Your other account likely has a qualifying Power Automate premium license assigned to it, which activates the automated scheduling interface.
Can I automate Excel tasks locally without a cloud subscription?
Yes. If you recreate your tasks using traditional VBA macros instead of cloud-based Office Scripts, you can use the built-in Windows Task Scheduler to open your workbook and execute the macro automatically each day.
Is Power Automate the only way to schedule Office Scripts natively?
Yes, for native, cloud-based execution of modern Office Scripts, Power Automate is the required service within the Microsoft ecosystem. You must have the corresponding subscription to unlock these automated triggers.




