How do I refresh data manually in Excel?

There are several ways to refresh MarketXLS data in Excel, from quick keyboard shortcuts to automatic refresh settings.

Quick Refresh Methods

Keyboard Shortcuts

Shortcut	Action
Ctrl + Alt + F5	Refresh all data in the workbook
Ctrl + F5	Refresh current worksheet only

Using the Ribbon

1. Go to the Data tab
2. Click the Refresh All button (two green circular arrows)
3. All MarketXLS functions will update

Right-Click Refresh

1. Right-click on any cell with a MarketXLS function
2. Select Refresh

Automatic Refresh

Set Up Auto-Refresh

1. Go to Data tab > Queries & Connections
2. Right-click on your data connection
3. Select Properties
4. Check Refresh every X minutes
5. Enter your desired interval (e.g., 5 minutes)

Refresh on File Open

In the same Properties dialog:

• Check Refresh data when opening the file
• Your data will always be current when you open the workbook

Streaming Functions (Real-Time)

For truly automatic updates, use MarketXLS streaming functions:

=QM_Stream_Last("AAPL")
=QM_Stream_Bid("MSFT")
=QM_Stream_Ask("GOOGL")

Streaming functions automatically update as new market data arrives - no manual refresh needed.

Note: Streaming functions require an Advanced or Business subscription and are only active during market hours.

Troubleshooting Refresh Issues

Data Not Updating?

1. Check your internet connection
2. Verify MarketXLS is loaded - Look for the MarketXLS menu
3. Check market hours - Some data only updates during trading hours
4. Restart Excel - Sometimes a fresh start helps

Slow Refresh?

• Reduce the number of functions on a single sheet
• Use fewer real-time streaming functions
• Close other heavy applications

Best Practices

• Don't over-refresh - Excessive refreshing won't give you newer data
• Use streaming for real-time needs - More efficient than constant manual refresh
• Refresh before analysis - Always refresh before making trading decisions

Need Help?

Contact support at support@marketxls.com if you're having refresh issues.