Does more RAM make Excel faster?

If you are running out, yes, and large workbooks with many pivots and images do consume real memory. If memory pressure is comfortable, more will not help, because the usual bottleneck is single-core recalculation speed and the structure of the formulas themselves.

Do more CPU cores help with spreadsheets?

Less than you would expect. Some operations use multiple cores, and much of the recalculation path is single-threaded, so one fast core beats many slower ones for this work. It is one of the few common workloads where core count is a poor guide to performance.

Why does my spreadsheet lag when typing?

Because it is recalculating after every keystroke. That is usually the formulas rather than the machine: volatile functions, whole-column references and large array formulas each force far more recalculation than necessary. Switching to manual calculation confirms it instantly.

Problems · Under load

Why is Excel so slow on my laptop?

Because much of what a spreadsheet does is single-threaded, and depends on how fast one core is rather than how many there are. A laptop with many cores can crawl through a recalculation while most of those cores sit idle, which is why spreadsheet performance so often surprises people.

The other half is the file itself. Volatile functions, whole-column references, array formulas across large ranges and links to other workbooks each multiply the work, and they are usually easier to fix than the hardware is.

First, notice when it happens

From the first minute

Lag on every edit, as the workbook recalculates after each keystroke, is a formula structure problem more often than a hardware one.

Only after minutes of use

Long recalculations and large imports run long enough for thermals to matter, and a thin laptop settles during them like any other sustained load.

The causes, ranked

1. Single-threaded recalculation

most common

How to confirm it

One core pinned while the rest idle during a recalculation. More cores do not help this part of the work.

The fix

Prioritise single-core speed when buying for spreadsheet work, not core count. This inverts the usual advice and is the reason a modest machine sometimes beats an expensive one here.

2. Volatile functions recalculating everything

most common

How to confirm it

Functions that recalculate on every change regardless of whether their inputs changed, such as certain lookup, offset and random functions.

The fix

Replace them with non-volatile equivalents. On a large model this is frequently the difference between instant and unusable, and it costs nothing.

3. Whole-column references and oversized ranges

common

How to confirm it

Formulas referring to entire columns rather than the used range, multiplied across thousands of rows.

The fix

Reference only the range that holds data, or use structured tables. This is the most common single cause of a slow workbook.

4. Memory pressure on large models

common

How to confirm it

Large workbooks with many sheets, pivot caches and images consume real memory, and 8GB machines start swapping.

The fix

16GB or more for serious spreadsheet work, and close other applications while working on a large model.

5. Links to other workbooks and external data

common

How to confirm it

Delays when opening or refreshing, especially when linked files are on a network drive or cloud folder.

The fix

Consolidate the data or set links to refresh manually. Network latency is often mistaken for a slow computer.

6. Manual calculation as a diagnostic

occasional

How to confirm it

Switching to manual calculation makes editing instant again, which proves recalculation is the bottleneck.

The fix

Use it while building, and recalculate deliberately. It is a good working habit on any large model rather than only a test.

Measure it instead of guessing

Run the test to see whether the machine holds up under sustained load, but interpret a healthy result carefully here: spreadsheet lag usually has nothing to do with sustained performance. A good curve alongside a slow workbook points firmly at the file rather than the laptop, which saves you buying hardware that would not have helped.

Run the free test

What software cannot tell you here

We cannot see your workbook, its formulas or its size, which the application's own tools analyse.
We cannot measure single-core speed specifically, which reviews of your processor report.

Asked, in people’s own words

Does more RAM make Excel faster?: If you are running out, yes, and large workbooks with many pivots and images do consume real memory. If memory pressure is comfortable, more will not help, because the usual bottleneck is single-core recalculation speed and the structure of the formulas themselves.
Do more CPU cores help with spreadsheets?: Less than you would expect. Some operations use multiple cores, and much of the recalculation path is single-threaded, so one fast core beats many slower ones for this work. It is one of the few common workloads where core count is a poor guide to performance.
Why does my spreadsheet lag when typing?: Because it is recalculating after every keystroke. That is usually the formulas rather than the machine: volatile functions, whole-column references and large array formulas each force far more recalculation than necessary. Switching to manual calculation confirms it instantly.

Name the cause. Three and a half minutes, in the tab you have open.

Run the test