Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteFix a slow Excel workbook by first identifying whether calculation, workbook clutter, add-ins, file location, or the data model is the bottleneck. Save a backup, test a local copy, then work through calculation settings, unused cells and objects, startup components, links, and oversized datasets. The safest changes preserve full precision and the original file until you verify the result.
1. Triage the slowdown before changing the workbook
Test a local copy
Save a copy to a local drive and open that copy. A workbook on a network share, web folder, SharePoint, redirected Documents folder, offline-files location, Remote Desktop/Citrix session, network appliance, or virtualized environment can appear slow because of storage or connection latency. If the local copy is responsive, investigate the storage path rather than rewriting formulas. Microsoft’s troubleshooting guidance covers these location tests: Excel not responding, hangs, freezes, or stops working.
As an Amazon Associate I earn from qualifying purchases.
Use the symptom to choose the first test
- Delay after editing a cell or pressing F9: investigate calculation, data tables, volatile functions, external links, and circular references.
- Slow opening or saving: check external links, unused formatted cells, excessive styles, shapes, hidden objects, startup files, and file size.
- Scrolling or selecting is slow: test Page Break Preview, shapes, objects, and display/driver issues.
- Only one computer is affected: test Safe Mode, add-ins, printer drivers, and available RAM.
- Importing data causes a warning: stop before saving over the source file; the worksheet grid may be too small for the dataset.
2. Control calculation without sacrificing accuracy
Choose the appropriate calculation mode
In Windows desktop Excel, open File > Options > Formulas > Calculation options > Workbook Calculation. The choices are:
| Mode | Behavior | Best use |
|---|---|---|
| Automatic | Recalculates dependent formulas as inputs change; this is the default. | Normal working files where current results matter immediately. |
| Partial | Recalculates dependent formulas but excludes data tables. | Workbooks whose data tables are the dominant calculation cost. |
| Manual | Recalculates only when explicitly triggered, such as with F9. | Diagnosis or controlled batch editing, with a deliberate final recalculation. |
In desktop Excel, the calculation setting applies to all open workbooks, not only the active file. In Excel for the web, use Formulas > Calculation Options; the labels are Automatic, Automatic Except for Data Tables, and Manual. The web setting applies only to the current workbook in that browser. Choose Calculate Workbook to force a full recalculation. See Microsoft’s current instructions at change formula recalculation, iteration, or precision in Excel.
#1 Best Overall
- Boosts System Performance:16GB DDR4 laptop memory that operates at 3200MHz to improve multitasking and system responsiveness for smoother performance
- Easy Installation: Upgrade your laptop RAM with ease—no computer skills required Follow step-by-step how-to guides available at Crucial for a smooth, worry-free installation
- Compatibility Guaranteed: Ensure seamless compatibility with your laptop by using the Crucial System Scanner or Crucial Upgrade Selector—get accurate recommendations for your specific device
- Trusted Micron Quality: Backed by 42 years of memory expertise, this DDR4 RAM is rigorously tested at both component and module levels, ensuring top performance and reliability for your Mac system
- ECC Type = Non-ECC, Form Factor = SODIMM, Pin Count = 260-pin, PC Speed = PC4-25600, Voltage = 1.2V, Rank and Configuration = 1Rx8 or 2Rx8
Manual mode is a diagnostic, not a cure. Microsoft recommends it to test whether automatic recalculation is causing hangs with complex formulas. Before sharing or relying on results, return to the intended mode and calculate the workbook.
Reduce calculation work at the source
- Replace formulas that reference entire columns with bounded ranges where the data has a known extent.
- Review data tables and automatic-recalculation (volatile) functions; both can trigger repeated work.
- Limit links to other worksheets and workbooks to the ranges actually needed.
- Inspect circular references before enabling iteration. Iterative calculation is at File > Options > Formulas > Calculation options > Enable iterative calculation. The controls are Maximum Iterations and Maximum Change; Microsoft’s current defaults are 100 iterations or stopping when every value changes by less than 0.001. More iterations or a smaller maximum change can lengthen calculation.
Use multi-threaded calculation appropriately
Go to File > Options > Advanced > Formulas > Enable multi-threaded calculation. It is enabled by default. To restrict resources, select Manual under Number of calculation threads and enter a value; Microsoft’s current calculation-options page allows up to 1,024, while its Advanced Options documentation says Excel supports up to 64 processor cores. Only workloads that can be split run concurrently, so enabling more threads will not make every formula multi-threaded. Details are in Microsoft’s calculation guidance and Advanced Options.
Do not use “Set precision as displayed” as a speed trick
The option at File > Options > Advanced > When calculating this workbook > Set precision as displayed permanently replaces stored full-precision values with the displayed precision. Turning it off later does not restore the original values. Keep it off unless deliberately changing the workbook’s numerical model.
Account for calculation-chain and version effects
Excel stores calculation-chain metadata so it does not have to determine formula order from scratch on every load; editing or recalculating can reorder that chain. An older workbook may also recalculate all formulas when first opened in a newer Excel version. After saving it in the current version, later opens can be faster. Microsoft explains the metadata in Excel calculation-chain metadata.
Rank #2
- A-Tech 16GB RAM Module, DDR4 SO-DIMM 260-Pin, 3200MHz PC4-25600 (PC4-3200AA)
- Non-ECC Unbuffered, JEDEC DDR4 Standard 1.2V Operating Voltage
- Compatible with select Laptop, Notebook, Mini PC, and All-in-One (AIO) systems. Please verify your system's memory type, form factor, and maximum supported capacity before purchasing
- Not compatible with desktop DIMM, non DDR4 memory, or ECC memory types such as RDIMM, LRDIMM, and ECC UDIMM
- Increases available memory capacity to enhance system responsiveness, application performance, and multitasking capabilities.
3. Remove workbook clutter that consumes resources
Clean unused formatted cells (Microsoft 365)
In current Excel for Microsoft 365, choose Review > Check Performance. The Workbook Performance pane reports used cells and cells that can be optimized. Select Optimize all for the workbook, or open a worksheet’s details and choose Optimize sheet. The feature targets hidden internal information such as formatting, blank cells, and non-printing characters. Excessive unused cells can slow or destabilize a file. Follow Microsoft’s instructions at Clean up cells in your workbook.
This feature is documented for Microsoft 365, not universally for Excel 2016, 2019, 2021, or 2024. Do not run it on Pixel Art worksheets: Excel cannot distinguish artwork from unwanted formatted cells and may remove it. Use Undo immediately if that happens.
Audit styles, names, objects, and shapes
Microsoft identifies these workbook-level trouble spots:
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problems- Formulas referencing entire columns.
- Array formulas whose arguments contain uneven numbers of elements.
- Hundreds or thousands of hidden, zero-height, or zero-width objects.
- Excessive styles created by repeated copy-and-paste between workbooks.
- Excessive or invalid defined names.
- Hundreds of thousands of geometric shapes or complex shape objects.
Extensive formatting and shapes can make an .xlsx large despite modest visible data. If available RAM is insufficient, Excel and other applications may become slow or unstable. Remove obsolete names, styles, objects, and shapes from a backup copy, then reopen and test.
Rank #3
- 256 GB SSD of storage.
- Multitasking is easy with 16GB of RAM
- Equipped with a blazing fast Core i5 2.00 GHz processor.
Check the worksheet view and printer path
Page Break Preview can slow Excel because it is printer-intensive. Switch to Normal view and test with a different printer driver. If performance changes, the workbook may be healthy while the printer or video-driver path is the problem.
4. Isolate add-ins and files that load at startup
Run Excel in Safe Mode
On Windows 10 or 11, open Start > All apps > Windows System > Run, enter Excel /safe, and select OK. Safe Mode bypasses alternative startup locations, changed toolbars, startup folders, Excel add-ins, and most COM add-ins. If the workbook is faster, continue with add-in and startup isolation. Microsoft’s procedure is documented at Excel not responding, hangs, freezes, or stops working.
Test COM add-ins one at a time
- Open File > Options > Add-ins.
- In Manage, select COM Add-ins, then select Go.
- Clear every check box and select OK.
- Restart Excel normally.
- Re-enable one add-in, restart, and test; repeat until the slowdown returns.
Inspect XLSTART and the alternate startup folder
Workbooks, templates, or workspace files in Excel’s XLSTART folder open automatically. To inspect configured trusted locations, use File > Options > Trust Center > Trust Center Settings > Trusted Locations; move suspected startup files elsewhere and restart Excel. Also check File > Options > Advanced > General > At startup, open all files in, temporarily move files from that folder, and restart.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →5. Manage external links and file-location overhead
Control link updates
Go to File > Options > Advanced > When calculating this workbook. Update links to other documents controls calculation and updating of formulas that reference other applications. Save external link values stores copies of values from linked documents. If links cover large ranges, clearing that option can reduce disk usage and opening time. Confirm that users can still refresh links when current data is required. See Advanced Options.
Rank #4
- 【Key Features】HP Laptop 14" – Simple, Reliable Everyday Computing for Students & Casual Users: This HP 14 laptop is designed for users who want a straightforward, easy-to-use device for browsing, streaming, studying, and daily tasks. Powered by Intel Processor N150 and built-in Intel Graphics, it delivers smooth performance for essential productivity, making it an ideal choice for students, seniors, and first-time laptop users looking for a dependable hp laptop experience.
- 【Efficient Performance for Everyday Tasks】Intel Processor N150 + Essential Multitasking: Equipped with an Intel Processor N150 (up to 3.6GHz) and 16GB DDR4 RAM, this hp 14 laptop handles web browsing, online classes, documents, and video streaming with stability and efficiency. It is optimized for light multitasking and daily productivity without unnecessary complexity, perfect for schoolwork and home use.
- 【Fast & Flexible Storage】128GB UFS + 256GB Expansion for Daily Needs: Enjoy fast boot times and responsive file access with 128GB UFS storage, plus an additional 256GB expansion for a total of 384GB combined storage. This HP laptop provides enough space for documents, school projects, apps, and media, making it a practical hp laptop 14 inch solution for everyday storage needs.
- 【Clear Display & Portable Design】14” HD Anti-Glare Screen for Comfort Viewing: The 14-inch HD (1366 x 768) micro-edge anti-glare display offers clear visuals and reduced eye strain, ideal for long study or browsing sessions. Lightweight at just 3.24 lbs, this portable hp 14 laptop is easy to carry between home, school, or travel, making it perfect for on-the-go lifestyles.
- 【Smart Features for Modern Users】Copilot AI, Wi-Fi 6 & Microsoft 365 Included: Stay productive with built-in Microsoft Copilot AI assistance, Wi-Fi 6 connectivity for faster internet speeds, and a 1-year Microsoft 365 subscription for Word, Excel, and PowerPoint. Enjoy a secure and simplified computing experience with Windows 11 Home in S Mode.
Separate content problems from location problems
Keep the local-copy test as a permanent diagnostic. If local performance is good but the shared copy is slow, involve the network, SharePoint, synchronization, or virtual-desktop administrator rather than adding more formulas or formatting changes.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.6. Handle datasets larger than the worksheet grid
Do not save over the source after a grid-limit warning
If Excel displays “This data set is too large for the Excel grid. If you save this workbook, you’ll lose data that wasn’t loaded,” saving over the original can permanently discard rows or columns that were not loaded. Preserve the source file.
Load the complete file into a PivotTable
- Open a blank workbook.
- Choose Data > From Text/CSV in Get & Transform Data.
- Select the file and choose Import.
- In the preview, choose Load To and select PivotTable Report. If Load To is hidden, select the arrow beside Load first.
The PivotTable can summarize the complete imported dataset without displaying every row in the worksheet grid. Microsoft’s procedure is at What to do if a data set is too large for the Excel grid.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Use a Data Model when millions of rows are required
Data Models are supported in Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016 and can contain millions of rows, but larger models consume more memory and can slow Excel and other applications. For Excel for the web in Microsoft 365, Microsoft’s current documented total file-size limit for workbooks containing Data Models is 250 MB; Microsoft says Microsoft 365 limits are not configurable and may change. Use the current Data Model specification and limits, rather than older articles that mention a 10 MB web limit. For memory-reduction techniques, see Create a memory-efficient Data Model using Excel and Power Pivot.
Best Value
- - 15.6" Full HD IPS Narrow Bezel, Anti-glare Display - 1920 x 1080 resolution delivers incredible detail, wide-viewing angles, and lifelike color reproduction. AMD FreeSync Technology syncs your display and refresh rate so you get fluid, artifact-free visual performance at virtually any framerate. Keeps up with hybrid work styles with a thin and light design and 85% screen-to-body-ratio.
- - Connect and collaborate on your terms - When it comes to staying connected with friends or collaborating with others, this 15.6-inch HP business laptop understands the assignment. Wide dynamic range HD camera ensures you always look your best during virtual conferences, in both bright and low-light conditions. Effectively collaborate with the integrated camera and AI-based noise reduction with dual-array mics.
- - Complete Port Selection & Faster Connectivity - Stay connected with a variety of ports, including 1x USB Type-C (5Gbps signaling rate), 2x USB Type-A (5Gbps signaling rate), 1x Headphone/microphone combo, 1x HDMI 1.4b. Enjoy a smoother online experience with Wi-Fi 6 and Bluetooth 5.3 technology, providing faster data transfer speeds and more stable connections than previous generations.
- - AMD Ryzen 3 7330U Processor - This efficient 4-core, 8-thread, 8 MB L3 cache, and up to 4.3 GHz max boost clock processor is suitable for your everyday business tasks. Multitask, analyze data, focus on 1080p video chatting, and edit photos or videos smoothly with responsive performance and vibrant visuals.
- - Weighs 3.4 lbs. & Measures 0.73" thin - A stable design that fits perfectly in your lap and desk, so you're never tethered to one place. 3-cell, 41 Wh Li-ion polymer battery.
7. Update Excel and account for known version-specific fixes
Microsoft’s troubleshooting page says Microsoft 365 Current Channel Version 2503 and later include fixes for PivotTable refresh performance, freeze-pane rendering, and geometric-shape loading. Version 2601 or later improves responsiveness during file-property or user-profile-card activity. Update Microsoft 365 before spending time rebuilding a workbook, especially one with PivotTables, freeze panes, or many shapes.
For slow Alt+ shortcut-key behavior, Microsoft documents a registry workaround for Office 365 version 1908 or later: in HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0Common, create a REG_DWORD named UseAsyncRibbonKeytips and set its value to 1. Registry changes affect the user profile; back up the registry and involve an administrator if required. The source is Tips for improving Excel’s performance.
8. Avoid legacy-format compatibility traps
Saving to Excel 97–2003 format can create performance, fidelity, or error problems. Excel 2007 and later support up to 64 levels of formula nesting, 255 function arguments, 1,024 operands, and 8,192 formula characters; the older format has substantially lower limits. Exceeding those limits can convert formulas to #VALUE! when saved.
- Structured table references work in Excel 2007 and later but become ordinary cell references in Excel 97–2003 format.
- Array formulas exceeding earlier-format limits, including arrays larger than 256 columns or 65,536 rows, may fail to save correctly or produce different results.
- Text-heavy workbooks using
LEN,MID,SEARCH,FIND, orREPLACEcan have compatibility-related performance issues. Ensure these functions use the appropriate Compatibility Version in File > Options.
Keep the modern .xlsx or .xlsm format whenever recipients support it, and test a separate compatibility copy before delivering an old-format file.
Quick Recap
A safe repair order
- Make a backup and test a local copy.
- Open in Safe Mode to rule out add-ins and startup files.
- Observe whether editing, opening, saving, scrolling, or importing is the slow operation.
- Test calculation mode; inspect data tables, volatile formulas, links, and circular references.
- Leave “Set precision as displayed” off and avoid destructive precision changes.
- Run Check Performance in Microsoft 365, while protecting Pixel Art sheets.
- Remove unnecessary styles, names, hidden objects, shapes, and whole-column references.
- Review external-link settings and shared-storage latency.
- For oversized data, load to a PivotTable or Data Model instead of forcing every row into the grid.
- Update Excel and save in a modern format; recalculate and verify key outputs before replacing the original.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
