If you want to ensure that up-to-date data is always displayed when you display the workbook in Excel Services, select the Refresh data when opening the file check box by using Office Excel. To refresh a workbook, press Ctrl + Alt + F5. End Sub. Cancelled means that Excel did not issue the refresh request, probably because refresh is disabled on the connection. It's good to hear it's working for you. Two Excel workarounds for automatic refresh and recalculation There are two ways to make Excel automatically refresh data connections and recalculate a worksheet. I've been stuck in automatic updates of data in excel. To refresh the data when you open a workbook, you must enable the data connections by using the Trust Center bar, or you must place the workbook in a trusted location. Its a workaround and not perfect, but its possible and doesnt need a macro-enabled worksheet. Note:To stop a refresh, press Esc. (On the Data tab, in the Connections group, click Connections, select the connection, click Properties, click the Usage tab, and then click Refresh data when opening the file.) Status of the refresh is indicated for each connection used in the data model. A Web Part author can select or clear the Allow Excel Web Access Periodic Data Refresh property to allow or prevent periodic refresh. Choose the account you want to sign in with. You could have opened the Workbook through Windows Job Scheduler periodically and closed it after refresh within Macro. Select the table then choose Data | Get Data | From other sources | from Table/Range. could be extracted into a separate program. vegan) just to try it, does this inconvenience the caterers and staff? On your worksheet, click any cell that contains your OLE DB data. Keyboard Shoetcut Ctrl+Alt+f5 Regards Gokul Poddar_Vikash (Vikash Poddar) July 7, 2022, 6:37am 5 I don't want to open the sheet @Gokul001 Thanks for the reply AkshaySandhu (AkshaySingh Sandhu) July 7, 2022, 6:44am 6 I'll give it a try. Note:If you have more than one workbook open, you'll need to repeat the operation in each workbook. Check out the latest Community Blog from the community!