Fix a slow or freezing MarketXLS workbook
Reduce unnecessary recalculation and streaming work before sharing a large or private workbook with support.
Start by testing one formula in a blank workbook. If the blank workbook is fast, the add-in and account are probably working, and you can focus on the size or design of the original workbook.
1. Save a test copy
- Save the original workbook.
- Create a separate copy for troubleshooting.
- Remove private holdings, customer names, account numbers, and unrelated worksheets from the test copy.
Don't send the original workbook to support if it contains sensitive information.
2. Use Refresh Selected first
Refresh All recalculates MarketXLS formulas across the workbook. On a large workbook, this can create far more work than the few cells that you need to update.
- Select a small affected range.
- Use Refresh Selected or the Windows selected-range refresh control.
- Wait for the calculation to finish.
- Increase the range gradually.
Capture the Windows refresh group with both refresh scopes visible.
/images/docs/windows/refresh-controls.webp
If a small range is fast but Refresh All is slow, the delay is probably related to workbook scope, formula count, or the number of distinct requests.
3. Separate streaming from snapshot formulas
Streaming formulas stay subscribed to live symbols. Snapshot formulas request a value when Excel recalculates them.
- Pause streaming while you restructure a large workbook.
- Resume streaming when the workbook is ready to receive live ticks.
- Don't repeatedly use Refresh All to update a streaming formula. Confirm that streaming is on instead.
- Use an on-demand function when you don't need continuous ticks.
Capture the Microsoft 365 streaming control in its Paused state.
/images/docs/microsoft-365/streaming-paused.webp
Read Turn real-time streaming on or off for the controls on each add-in.
4. Reduce unique live symbols
An option-chain workbook can subscribe to many unique contracts even when every contract has the same underlying stock.
If you only need a table at one point in time, use an on-demand chain or quote instead of a streaming formula for every row. Use current and historical options data compares those choices.
- Close workbooks and Excel instances that you aren't using.
- Remove streaming rows for expired or unneeded contracts.
- Test one underlying and a small group of contracts.
- Check the symbol-usage value shown by the add-in when available.
- Replace streaming formulas with on-demand functions where live ticks aren't necessary.
If the workbook reports Symbols limit is exceeded, Rejected, or Not Entitled, follow Fix Please Refresh, Loading, and NA.
5. Confirm which add-in the workbook uses
Desktop Excel on Windows can have both MarketXLS add-ins available:
- The Windows desktop add-in uses formulas such as
=Last("MSFT"). - The Microsoft 365 add-in uses formulas such as
=mxls.Last("MSFT").
Use one intended formula family while you troubleshoot. Read Compare formula syntax by platform before you convert formulas.
6. Isolate the slow section
In the test copy:
- Refresh one worksheet at a time.
- Within a slow worksheet, test smaller ranges.
- Record the approximate number of MarketXLS formulas in the slow range.
- Record whether the range contains snapshot, streaming, list, or option-chain functions.
- Record the elapsed time for Refresh Selected and Refresh All.
This information is more useful than saying that Excel “hangs,” because it shows whether the delay grows with the formula count, unique symbols, or one function family.
Contact support without sharing private holdings
If the workbook remains slow, contact MarketXLS support and include:
- Windows or Microsoft 365 add-in
- Excel version and operating system
- Approximate workbook size and MarketXLS formula count
- The slowest function family
- Elapsed time for a small selection and the whole workbook
- Whether pausing streaming changes the result
- A sanitized test workbook, if you can reproduce the issue without private data
If you can't share any workbook, offer a screen-sharing session and prepare the sanitized diagnostic details first.