If Excel is very slow loading data, first identify whether the delay happens while opening the workbook, recalculating formulas, or refreshing an external data source; each points to a different cause. Then test a copy of the file with unnecessary add-ins disabled and calculation set to Automatic, and reduce the workbook or query work that is actually slowing it down.
First identify what “loading” means
A workbook can feel slow at several different stages. Excel may take a long time to open a file, pause while calculating after it opens, freeze while a query retrieves data, or respond slowly when you scroll and filter. Treating all of these as the same problem can lead to unhelpful fixes, such as changing calculation settings when the real delay is a network connection.
Notice when the delay occurs and whether it happens in one workbook or every workbook. If a blank workbook opens quickly but one particular file does not, the file’s formulas, connections, formatting, or size are likely involved. If every workbook is slow, consider Excel add-ins, an Office update, a device resource limit, or a broader problem with the installation.
- Slow before the workbook appears: investigate file size, startup add-ins, network storage, and linked files.
- Slow after editing a cell: investigate formula calculation and dependency chains.
- Slow during Refresh All: investigate the data source, Power Query steps, and connection settings.
- Slow when scrolling or filtering: investigate excessive formatting, objects, or a very large used range.
Check the workbook and where it is stored
Start with a copy of the workbook so that experiments do not put the original at risk. If the file is on a network drive, SharePoint, OneDrive, or a synchronized folder, save a copy to a local folder and compare opening and refresh times. A faster local copy suggests that network latency, synchronization, permissions, or the remote data source contributes to the delay. It does not prove that the workbook itself is healthy; both causes can be present.
File size is a clue, not a diagnosis. A large workbook may contain useful data, but its size can also come from embedded images, many formatting records, objects, pivot caches, or data stored in the workbook’s Data Model. Excel worksheets have a limit of 1,048,576 rows and 16,384 columns, but a workbook can become cumbersome well before reaching those limits, depending on the computer and what it contains.
Press Ctrl+End on Windows to see the last cell Excel considers used on the current worksheet. If it jumps far beyond the real data, stray formatting or old content may have enlarged the used range. Do not delete rows or columns blindly: first make a backup, identify the truly empty area, clear its contents or formatting as appropriate, save, close, and reopen the file. Excel for Mac also has a Go To Last Cell command; its shortcut can differ with keyboard layout and settings.
Test Excel without add-ins
An add-in can slow startup, interact with a workbook, or make Excel unstable. To test without most custom startup components on Windows, close Excel, press Windows key + R, enter excel /safe, and open the workbook. Safe Mode is a diagnostic test, not a permanent repair. If the file is faster there, an add-in or startup customization is a reasonable suspect.
To review COM add-ins in Microsoft 365 for Windows, open File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. Turn off an add-in for a test, restart Excel normally, and compare. Excel add-ins are managed separately in the same Manage area; disable only items you recognize and can safely test. Re-enable items one at a time to find a likely cause rather than removing everything at once.
Excel for Mac does not use the Windows excel /safe command or the same COM Add-ins interface. Review installed Office add-ins using Excel’s Add-ins controls, and test a clean workbook or another user profile if needed. If Excel remains slow across files, install current Office updates and, on Windows, consider repairing Microsoft 365 through Windows Settings > Apps > Installed apps > Microsoft 365 > Modify. Available repair choices can vary by installation.
Reduce unnecessary formula recalculation
Excel normally recalculates formulas when their inputs change. A workbook with many formulas, large array calculations, or long chains of dependencies may take time to calculate, especially when a frequently changing input forces downstream formulas to update. Functions such as NOW, TODAY, RAND, and RANDBETWEEN are volatile: they recalculate more often than ordinary formulas. Many formulas that refer to entire columns can also create unnecessary work, particularly when repeated across a large number of cells.
Look for formulas copied far beyond the actual data, repeated lookups that could be performed once, and calculations over unnecessarily large ranges. Use Excel Tables or appropriately bounded ranges where they fit the task. Avoid replacing formulas with hard-coded values unless you are deliberately freezing results and understand that they will no longer update.
Calculation mode is under Formulas > Calculation Options. Automatic is the normal setting for most workbooks. Manual calculation can make editing a calculation-heavy file feel faster, but it also means displayed results may be stale until recalculation. If you use Manual temporarily, recalculate with F9 and return to Automatic when finished. Calculation mode can affect other open workbooks in the same Excel session, so check the setting before trusting a result or sharing the file.
Diagnose slow Power Query and external connections
If the delay happens during a refresh, open Data > Queries & Connections to see the workbook’s queries and connections. Refresh one query at a time, when possible, to identify which source is slow. A query that reads a large database table, a remote file, or a folder containing many files may take much longer than one that reads a small local table. Check whether the source itself is slow to respond before assuming Excel is responsible.
Power Query transformations can add work, particularly when they process a large amount of data. Filter rows and remove unused columns early when the source and query support those operations. For some databases, Power Query can fold supported steps back to the source so that the source performs part of the processing. Not every source or transformation supports folding, so do not assume that moving a step earlier will always improve performance. Previewing a query and loading its final results can also take different amounts of time.
Decide whether a query needs to load every result into a worksheet. A worksheet is convenient for direct inspection and formulas, but it is not always the best destination for a large dataset. Depending on the task, loading to the Data Model or creating a connection without a worksheet table may be more appropriate. These choices change how you access and analyze the data; they are not interchangeable with simply making a refresh faster.
For external links, check whether linked workbooks are available and whether the paths still point to the intended files. A workbook may wait for a network location or prompt about updating links. Do not break links just to improve speed unless you have confirmed that the workbook no longer needs the linked values or formulas.
Remove excess formatting and workbook clutter
Formatting applied to huge unused ranges can increase file size and make some operations slower. Select only the genuinely unused rows or columns after your data, clear unwanted formatting, then save and reopen the workbook. If the issue is limited to a particular sheet, compare it with a newly created sheet rather than assuming every worksheet needs the same cleanup.
Conditional formatting deserves a check when a workbook has accumulated many rules. Select a relevant cell and use Home > Conditional Formatting > Manage Rules to inspect the rules and their ranges. Rules applied to entire columns or duplicated across overlapping ranges may require more work than rules scoped to the actual data. Preserve rules that carry meaning, and test any cleanup against a copy because changing a range can alter what users see.
Pictures, shapes, comments, and embedded objects may contribute to a large file, though they are not automatically the cause of a slow refresh. PivotTables can also retain cached data. Before removing any object or cache, confirm whether the workbook’s reports depend on it. Saving a working copy in the modern .xlsx format may reduce the overhead of an older .xls file, but format conversion can affect macros or legacy features; macro-enabled workbooks generally need the .xlsm format.
Check memory, file format, and Excel version
Large workbooks and data models need memory. A 32-bit edition of Excel has less address space available to the application than a 64-bit edition, which can matter for memory-intensive files. The choice is not a universal speed upgrade: compatibility with older add-ins or other software may influence which edition is suitable. In Excel, check File > Account > About Excel to see version information, including whether the installation is 32-bit or 64-bit.
Close unrelated applications while diagnosing a workbook that consumes substantial memory, and make sure the device has available storage. If Excel reports that it cannot complete an operation or becomes unresponsive with large datasets, review the workbook’s memory demands rather than repeatedly forcing the same refresh. For data beyond a practical worksheet workflow, a database or another data-analysis tool may be a better fit.
Excel for the web and desktop Excel do not have identical capabilities or performance characteristics. A workbook that depends on desktop connections, add-ins, or advanced features may behave differently in a browser. Compare using the same file and data source, and note any unsupported features before concluding that one version is simply faster.
A practical troubleshooting order
Change one thing at a time and record whether the delay improves. This makes it easier to identify a cause and undo a change that affects results. A useful order is:
- Save a backup and note whether the delay is opening, calculating, refreshing, or interacting with the sheet.
- Test a local copy and compare it with the original storage location.
- Open Excel in Windows Safe Mode or disable a suspected add-in, then compare the same workbook.
- For refresh delays, test individual queries and confirm that the source is available and responsive.
- For calculation delays, inspect large formula ranges, volatile functions, and the calculation mode.
- For interface or file-size problems, inspect the used range, conditional formatting, and unnecessary objects.
- Install Office updates and consider a repair if several workbooks remain slow.
Use elapsed time as well as the impression of responsiveness. For example, if a sales workbook takes 20 seconds to refresh from a shared folder but 4 seconds from a local copy, that points toward the source location or connection path. If both copies take about 20 seconds and one query accounts for nearly all of it, inspect that query and its source. Those timings are clues, not proof; repeat the comparison under similar conditions.
Frequently Asked Questions
Why does Excel take so long to open a file?
Possible causes include a large workbook, startup add-ins, external links, network storage, or a slow startup location. Compare a local copy, test Excel in Safe Mode on Windows, and see whether other workbooks open normally.
Why is Excel slow when I refresh data?
The delay may come from the source, the network, the amount of data retrieved, or Power Query transformations. Use Data > Queries & Connections to identify the query, then test it separately and check source availability.
Will changing calculation to Manual make Excel faster?
It can reduce recalculation pauses while editing a formula-heavy workbook, but results may remain out of date until recalculated. Use it as a temporary diagnostic or workflow choice, press F9 when needed, and restore Automatic when appropriate.
Does a large Excel file always need to be split?
No. File size alone does not show whether the workbook is inefficient, and splitting can make linked analysis harder. First find what occupies space and whether the delay is calculation, refresh, storage, or display. Consider a database or Data Model when the worksheet is not a practical destination for the dataset.
Is Excel for the web slower than desktop Excel?
Not in every situation. Speed depends on the workbook, source, browser, network, and features being used. Compare the same task in both versions and check whether the workbook relies on desktop-only capabilities.
Related
- When Was Excel Created? The 1985 Launch Explained
- Excel Weekday Text: Show Dates as Day Names
- Excel WEEKDAY: Return a Day Name from a Date
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Email Address Cache in Outlook: Step-by-StepTo clear Outlook’s remembered email addresses, remove individual suggestions with the X beside them, or, in classic Outlook…
- How to Double Space a Paragraph in Microsoft WordTo double-space a paragraph in Microsoft Word, click anywhere in the paragraph, then choose Home > Line and…
- Can You Split One Cell in Excel? What Actually WorksNo—Excel cannot divide one individual grid cell into two smaller cells without changing the worksheet’s row-and-column structure. You…
- Mail Merge in Word: A Step-by-Step GuideTo do a mail merge in Word, prepare a recipient list, connect it to a Word document, insert…
- Excel Insert Row Shortcut: Fast Ways for Windows and MacExcel has no built-in shortcut named “IR.” If you mean insert row, select the row with Shift+Space, then…
- How to Make Cell Borders White in Microsoft Excel 365To make cell borders white in Excel, select the cells, open Home > Borders > More Borders, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.