--- title: Refreshing your Spreadsheets Automatically Offline description: Learn how to run automatic operations when you're offline. --- [Skip to content](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#main-content) English Show submenu for translations ![Xappex-logo-with-name.png\]](https://knowledge.xappex.com/hs-fs/hubfs/Xappex-logo-with-name.png?height=40&name=Xappex-logo-with-name.png) - [Products](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#products) - [Blog](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#blog) - [About](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#about) Open main navigation Close main navigation - [Products](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#products) - [Blog](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#blog) - [About](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#about) - English Show submenu for translations - Go to xappex.com Go to xappex.com Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Xappex Knowledge Base](https://knowledge.xappex.com/?hsLang=en) 2. [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en) 3. [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365) # Refreshing your Spreadsheets Automatically Offline ## Learn how to run automatic operations when you're offline. The most powerful feature of XL-Connector 365 is the ability to create an automatic schedule that will run in your absence and repopulate a workbook stored in OneDrive or SharePoint with the most up-to-date data from Salesforce. This is analogous to Refreshing the data manually, the only difference is that the data will get refreshed automatically on the schedule you define. You can automatically refresh your data up to every 5 minutes! In order to be able to schedule the automatic data refresh – you will first need to log in to OneDrive with your Microsoft account: ![](https://www.xappex.com/wp-content/smush-webp/2018/12/LoginToMS.png.webp) If you are working on a desktop version of Excel, you will need to save your document to OneDrive in order to access this feature. If the document is saved locally, you will see the following error message: ![](https://www.xappex.com/wp-content/smush-webp/2018/12/NotConnectedToSharePoint.png.webp) Once the document is saved to OneDrive or SharePoint, click on Try Again and you will be taken to the Microsoft login screen as shown above. Once you log in to Microsoft, you’ll be taken to the following screen: ![](https://www.xappex.com/wp-content/smush-webp/2018/12/new_action.png.webp) Click on the **New Action** button to schedule any of your existing Flows for execution: ![](https://www.xappex.com/wp-content/smush-webp/2018/12/scheduler-action.png.webp) There are two default flows available: Pull Data and Push Data. This is where all flow steps are saved by default. You can also schedule any of your custom flows for automatic execution. For each flow, you can define which worksheets you would like the action to run for or simply check **All Worksheets**. The action can run Hourly, Daily, or Weekly. You can create multiple schedules for one document, which makes it possible to define pretty much any combination of schedules. You can choose whether to receive error and/or success email notifications. Click on **Save** to save and start the schedule. #### Refreshing Protected Sheets It is possible to refresh protected sheets with XL-Connector 365.  This feature lets you refresh the protected sheets if you provide the password  in the Options section of the app when you pull the data. ![](https://www.xappex.com/wp-content/smush-webp/2018/12/Screenshot_1.jpg.webp) - [I use Google Sheets](https://knowledge.xappex.com/i-use-google-sheets?hsLang=en) - [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#main-content) - [FAQs](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#faqs) - [I use XL-Connector](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector) - [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365) - [I use Excel Merge package](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-excel-merge-package) - [I use Looker Studio](https://knowledge.xappex.com/i-use-looker-studio?hsLang=en) - [Products](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#products) - [Blog](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#blog) - [About](https://knowledge.xappex.com/refreshing-your-spreadsheets-automatically-offline#about) [![Chill listening crop-3](https://knowledge.xappex.com/hubfs/Xappex-Logo.svg "Chill listening crop-3")](https://www.xappex.com) xappex.com Help Center Copyright © 2026, Xappex LLC