If Excel is not getting data, first open the Data tab and select Refresh All; then check that the source file, connection, and sign-in details are still available. If nothing changes or an error appears, identify whether the issue is a Power Query import, an external workbook link, a web connection, or a formula—each needs a different fix.
Start with the quickest checks
Before editing a query or rebuilding a workbook, check the simple causes. A refresh can fail because a file was moved, a network drive is unavailable, a password expired, or Excel is showing a cached result rather than newly retrieved data.
- Confirm that you opened the workbook that contains the query or connection, and that you are connected to the required network or VPN.
- Check for a yellow security or sign-in bar near the top of Excel. Only enable external content when you recognize and trust the workbook and its source.
- On the Data tab, select Refresh All. Wait for refresh to finish; large files and remote sources can take time.
- Open Data > Queries & Connections to see whether a query reports an error or is still refreshing.
- Check whether the expected output is hidden by a filter, placed on another worksheet, or loaded as a connection without a visible table.
If Excel reports a specific error, note its wording and the query or connection name. That detail often points directly to a missing file, denied access, or a changed column.
How Excel retrieves external data
Excel can get information in several ways. Power Query imports and reshapes data from files, databases, websites, and other supported sources. External workbook links refer to cells in another workbook. Other connections may retrieve data from a database or online service. These methods have different refresh controls, so the phrase not getting data does not identify one single setting.
Power Query can load results into a worksheet table, into the Data Model, or as a connection only. A connection-only query may refresh successfully without adding a visible table to the current sheet. In Data > Queries & Connections, inspect the query and its load destination before assuming the import failed.
Also distinguish retrieved data from formulas. A formula that refers to cells already in the workbook is recalculated by Excel; it does not fetch the source file or refresh a query. A linked-workbook formula, by contrast, depends on an external workbook link.
Refresh a Power Query import
For a query made with Power Query, select Data > Refresh All, or right-click the query in the Queries & Connections pane and choose Refresh. To investigate a failure, double-click the query to open Power Query Editor. Select the step that shows an error in the Applied Steps list and read the message in the preview.
Common errors include a source file that cannot be found, credentials that are no longer valid, and a transformation step that expects a column that has since been renamed or removed. Fix the underlying problem first. For a renamed field, for example, edit the affected step to use the new column name rather than repeatedly refreshing the unchanged query.
When the preview is correct, select Home > Close & Load to return the query results to Excel. If the query is intended to load somewhere specific, check its load settings instead of creating a second import. Excel for Mac also supports Power Query features, though available connectors and interface details can differ by release. Excel for the web has more limited query-editing capabilities than the desktop app.
Check the source path and file format
A query may work on one computer and fail on another because its source path points to a local location such as a user-specific Downloads folder. Moving or renaming the source file also breaks a query that expects the original path. Confirm that the file exists at the location the query uses and that you have permission to open it.
For a text or CSV file, the usual Windows import route is Data > Get Data > From File > From Text/CSV. Review the preview for the expected delimiter, encoding, and column types before loading. A comma-separated file opened with the wrong delimiter may appear as one column; dates or leading zeroes can also be interpreted differently from what the source intended.
When the source file is replaced regularly, keep its name and location consistent if possible. If that is not practical, edit the source step in Power Query rather than deleting and recreating every transformation. For files stored on a shared drive or cloud service, verify that the current account has access and that the location is available while refreshing.
Review credentials and permissions
Online services, databases, and some shared locations require credentials. A password change, expired sign-in, revised access policy, or account switch can make a previously working connection fail. Follow the sign-in prompt for the trusted source, and check with the data owner if your account may have lost permission.
In Excel for Windows, Power Query data-source permissions can be reviewed through Data > Get Data > Data Source Settings. The available options depend on the connector and Excel build. Clear or edit stored permissions only when you understand which sources are affected; removing credentials can cause other queries to ask for sign-in again.
For workbooks obtained from email or the internet, Excel may restrict external content as a security measure. Do not bypass warnings for an unfamiliar file. Ask the sender or your organization’s administrator to verify the workbook and source. In managed workplaces, policy settings can prevent users from changing some connection or security options.
Fix external workbook links
If values come from another Excel workbook, check the external link rather than the Power Query pane. In Microsoft 365 for Windows, Data > Workbook Links displays links Excel recognizes and provides options to update or change a source. The exact controls can vary with the workbook and Excel version.
Make sure the source workbook is available at the expected path and that you have permission to open it. A link may still display an old value if Excel cannot reach the source. If the link points to a renamed file or a different folder, use the link-management controls to choose the correct source. Do not break a link merely to silence a warning: breaking it replaces linked formulas with their current values, so the workbook will no longer update from that source.
Excel for Mac has link-management features too, but the placement and labels can differ by version. If you do not see Workbook Links, check the Data tab and the app’s available update options rather than assuming every Windows instruction maps exactly to Mac.
When the data is present but looks unchanged
A successful refresh does not guarantee that the displayed result looks different. The source may contain no new records, a filter may hide them, or the query may have loaded to a different sheet. Check the refresh time or source data, remove or adjust filters temporarily, and confirm the query’s destination in Queries & Connections.
If the displayed value comes from a formula, check Formulas > Calculation Options and select Automatic if appropriate. Manual calculation can leave formula results unchanged until recalculation. Pressing F9 recalculates open workbooks in Windows; it does not refresh a Power Query connection or repair a missing external source.
Another common misconception is that Refresh All updates every kind of data in every circumstance. It refreshes supported connections, but it cannot restore access to a missing file, grant database permissions, or correct a broken formula. Identify the mechanism first, then use its specific refresh or repair action.
Choose a reliable way to prevent repeat failures
Once the workbook works again, reduce the chance that the same issue returns. Stable paths, clear ownership, and a documented refresh process are more useful than repeatedly rebuilding imports. For a workbook used by several people, test that the intended users can access both the workbook and its source.
- Keep source files in an agreed shared location and avoid relying on one person’s local folders.
- Document which account or team owns access to a database or online source, without putting passwords in the workbook.
- Use clear query and worksheet names so refresh errors are easier to identify.
- Before changing a working query, save a separate copy of the workbook or make a controlled version of the file.
- Ask the source owner whether the schema, column names, or access policy changed if errors begin after an upstream update.
For recurring imports, Power Query is often easier to maintain than manually copying and pasting data because its transformation steps can be rerun. It still depends on a reachable source and valid permissions, so it is not a substitute for access management or a stable data feed.
Frequently Asked Questions
Why is Excel not updating data when I click Refresh All?
Refresh All cannot fix a missing source, expired credentials, denied permissions, or an error in a query step. Open Data > Queries & Connections, identify the failed connection, and inspect its source and error message.
Why does Excel say it cannot find the source file?
The file may have moved, been renamed, or be on a drive that is not currently connected. Restore the expected path or edit the query’s source location, and confirm that your account can access it.
Why does Refresh All finish but no new rows appear?
The source may have no new rows, filters may hide them, or the query may load to another destination or as connection only. Check the query preview, destination, and worksheet filters before rebuilding the import.
Does F9 refresh data from a website or database?
No. F9 recalculates formulas; use the connection’s refresh command for imported or connected data. A formula that displays an old value and a query that has not refreshed are separate problems.
Why does a workbook work for a coworker but not for me?
Your coworker may have different file paths, network access, permissions, or saved credentials. Compare source locations and access rights, but do not share passwords or copy credentials into the workbook.
Can Excel refresh data automatically when I open a workbook?
Some connections expose refresh-on-open settings. In Windows, inspect the connection or query properties from Data > Queries & Connections; options vary by connection type and Excel version. Automatic refresh still requires a reachable source and valid access.
Related
- Excel Not Equal: The <> Operator Explained
- Excel Arrow Keys Not Moving Between Cells? Quick Fixes
- Excel Not Responding? Causes, Fixes, and Recovery Steps
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Row Numbers Blue? Why It Happens and How to FixBlue row numbers in Excel usually mean that a filter is active on the worksheet, so some rows…
- Excel Hyperlink Not Working After Copying? Causes and FixesIf an Excel hyperlink stops working after you copy it, first check whether the paste kept the hyperlink…
- Why Is My IFERROR Formula Not Working in Microsoft Excel?Your IFERROR formula usually appears not to work because Excel is not evaluating the formula you think it…
- Excel SUMIFS Not Working? Causes and FixesYes—Excel SUMIFS can return zero, the wrong total, or an error when its ranges, criteria, or data types…
- Excel MID Formula Not Working? Fix the Common CausesIf Excel’s MID formula is not working, first check that its arguments are in the right order: =MID(text,start_num,num_chars).…
- Excel Workbook Not Scrolling? Fix the Common CausesIf an Excel workbook will not scroll, first check View > Freeze Panes > Unfreeze Panes, then check…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.