Refresh MarketXLS data
Update a selection or an entire workbook and check whether the source has newer data.
Refresh a workbook when you want MarketXLS to request current values. A refresh can update the formula result, but it can't make an exchange publish data before the exchange makes that data available.
A refresh and a streaming toggle do different things. Refresh recalculates a snapshot or formula request. Streaming functions update when QuoteMedia sends a new tick and streaming is on. See Turn real-time streaming on or off.
Refresh the Windows desktop add-in
- Open the MarketXLS ribbon tab.
- To update the whole workbook, select Refresh All.
- To update part of the workbook, select the relevant cells and choose the command for refreshing the selection.
- Wait for Excel to finish calculating before you edit the workbook again.
Capture the Windows refresh group with both refresh actions and streaming state.
/images/docs/windows/refresh-controls.webp
Refresh the Microsoft 365 add-in
- Open the MarketXLS (Web) ribbon tab.
- Select Refresh All to update the workbook, or select Refresh Selected after you select the cells to update.
- Wait for the formulas to finish calculating.
Capture Refresh All, Refresh Selected, and Toggle Streaming in one ribbon crop.
/images/docs/microsoft-365/refresh-controls.webp
Refreshing the Microsoft 365 add-in doesn't disconnect active QuoteMedia subscriptions. Streaming formulas continue from their existing connection.
Check the result
Confirm that:
- Excel no longer shows a calculation status.
- The formula still refers to the intended symbol and period.
- The market or reporting period has newer data available.
If a refresh doesn't change the value, check data coverage and delays. If many formulas are slow, follow Fix a slow or freezing MarketXLS workbook.