The standard method of forcing automatic update of Excel is a short snippet of VBA code. Most of them default OFF. Create a small table with a single cell. Normally Excel will update itself when you change a cell value. These days there are situations where cells change value but Excel does NOT update the worksheet. Wait at least 30 seconds for an accurate measurement. The higher the refresh rate… Click the “Advanced Settings” link to change its settings. Facts & prices. As it stands, we need workarounds to make it happen. Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint and doubtless many other names are registered trademarks of Microsoft Corporation. The Stock and Geo data types are curious beasts. Any Excel data query comes with some refresh options in the Query properties. Real-Time Excel – get live stock prices, currency rates and more, PivotTables and PivotCharts from scratch, for Microsoft Excel, Everyday Backups – protecting your documents, photos and personal info. The longer this test runs, the more accurate the refresh rate test becomes. We’ve got the same result using a data connection from a table in the worksheet. The full code is at the bottom of the article. Some external factor is needed to make Excel update Now() and the rest of the worksheet. The cell can have anything but we create a cell with NOW() in it, for reasons we’ll explain later. That means you can’t setup an automatic data refresh, as you would with normal data connections. Higher refresh rates can reduce the amount of flicker seen on the screen. These tricks are more important with the Stock data type in Excel  for Microsoft 365 customers. does the actual refreshing of data connections ( Workbooks(ThisWorkbook.Name).RefreshAll ) and we added two, optional,  lines to display the last time refreshed on the bottom status bar. Some displays may not have the maximum refresh rate set by default. Here’s what we use, there are many variations on the same theme. To change a monitor’s refresh rate on Windows 7, right-click your desktop, and then select the “Screen Resolution” command. Thanks for joining us! Typical display devices have refresh rates of 60Hz, 75Hz and higher. On a computer that is running Windows 7 and newer versions of Windows, you cannot change the Screen refresh rate for certain monitors. Please refer to the manufacturer documentation for supported refresh rates. New! But if there’s nothing to make that happen, Now() doesn’t change value. Users will want their worksheets to grab the latest prices automatically, something the current preview releases can’t do. With the Stock Data Type  the ability to update automatically is more important. Ideally, Excel would have an overall setting to refresh the worksheet every ‘n’ seconds or minutes. 1,000 pages, 40 chapter book shows you important features and details for Windows 10 users. It’s a workaround and not perfect, but it’s possible and doesn’t need a macro-enabled worksheet. Refresh every nnn minutes –  defaults off with 60 minutes suggested. If you have multiple displays connected to your PC, select the one you want to configure here. Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.