How Do You Restart Excel Without Losing Data?

How Do You Restart Excel Without Losing Data?

Do not kill Excel first. The order matters more than the method: give the application a few minutes to finish whatever it is doing, confirm that AutoRecover is switched on, and only then force it to close. When you reopen Excel, the Document Recovery pane offers you the last autorecovered version of the workbook, and in most cases that version is minutes old rather than hours old.

The panic reaction is to open Task Manager and end the process straight away. That is the one step that guarantees you lose everything typed since the last save, because Excel never gets the chance to write a recovery file. Almost every "I lost a day's work" story starts with a premature force-quit.

This guide covers what to do while the window is still frozen, how to restart cleanly, where to find recovery files when the pane does not appear, and how to set Excel up so the next freeze costs you two minutes instead of two hours.

Losing a morning's work to a frozen spreadsheet is a process problem, not bad luck. Get a free audit and see where your reporting workflow is fragile.

What should you do the moment Excel freezes?

Wait. A greyed-out window with "Excel is not responding" in the title bar usually means a calculation, a query refresh or an add-in is still running on the main thread, and the interface cannot repaint until it finishes. It is not necessarily a crash.

Large workbooks with volatile formulas, external data connections or heavy conditional formatting can hold the interface for several minutes and then return to normal with every keystroke intact. If you force-quit at minute two, you throw away work that would have come back at minute four.

Give it five to ten minutes before you do anything drastic. While you wait, do not click repeatedly in the window — each click queues another message Excel has to process when it recovers, and on Windows it can escalate the state to one the shell offers to close for you.

Two signals tell you the wait is worthwhile. First, if the mouse cursor still shows a busy state over the window, something is genuinely executing. Second, if the process is using meaningful CPU in Task Manager, it is working rather than deadlocked. A process sitting at zero percent CPU for ten minutes with no disk activity is the case where restarting is reasonable.

Resist the urge to reopen the same file in a second window to "check" it while the first is frozen. On a local file that produces a read-only copy and a lock conflict; on a synced file it can create a conflicted duplicate that you then have to reconcile by hand. Wait for the original window to resolve one way or the other.

Try to get a save in first

If the window becomes responsive even briefly, do not keep editing. Save immediately, with Ctrl+S, and if that stalls, use File > Save a Copy to write to a different name. Writing to a new file avoids whatever lock or path problem may have contributed to the freeze in the first place.

Where the ribbon is unresponsive but keyboard shortcuts register, Ctrl+S alone is often enough. It is worth one attempt before you move on.

Copy what you can see

If nothing responds and the data on screen is small enough, select the visible range and copy it. Even a frozen Excel window will sometimes serve a clipboard request. Paste it into a new workbook, a text editor or an email draft to yourself. It is crude, but a screen's worth of rescued numbers beats a clean restart with nothing.

Taking a screenshot of the visible sheet is the fallback when even copy fails. Retyping forty cells from an image is tedious; reconstructing them from memory is worse.

One habit makes all of this easier: keep a second Excel window closed while you work on anything heavy. If a second workbook is open in the same Excel process when the first one hangs, you risk both, and a force-quit takes down the innocent file alongside the problem one. Opening a genuinely separate instance for heavy work is possible on Windows by holding Alt while launching Excel and confirming the prompt.

How do you restart Excel so recovery actually works?

Close Excel the gentlest way that works, from least to most forceful, and check what came back before you do anything else.

1. Try the window's own close button. If Windows offers a dialog asking whether to close the program or wait for it to respond, choose to wait at least once. The program frequently recovers from exactly this prompt and hands control back.
2. Let Windows close it. If the application stays unresponsive after waiting, accept the offer to close the program. This route is better than Task Manager because the shell signals the application first, which sometimes allows a last recovery write.
3. Use Task Manager only if the window will not close at all. Press Ctrl+Shift+Esc, find the Excel entry, and end that task. On a Mac, use Force Quit from the Apple menu or Cmd+Option+Esc. Expect to lose everything since the last AutoRecover write.
4. Reopen Excel and read the pane before clicking anything. Excel launches with the Document Recovery pane listing files it saved for you. Each entry carries a timestamp and a label such as "AutoRecovered version". Open the newest one first.
5. Save the recovered version under a new name at once. The recovery file is temporary. Until you save it as a real workbook, it is still a candidate for cleanup, and reopening Excel again can discard it.

The fifth step is where people lose work they had already recovered. They open the recovered copy, confirm the numbers look right, carry on editing, and never save it as a file. Save first, inspect second.

Reporting that depends on one person remembering to save is reporting that will break. Get a free audit and find the fragile steps before they cost you.

Before you go looking on disk, check whether Excel simply reopened the file silently. Some crashes are recovered so cleanly that the pane never shows and the workbook on screen is already the recovered version. Look at the title bar for a "Recovered" or "AutoRecovered" marker, and check whether your last few edits are present, before assuming the work is gone.

Where are the recovery files if no pane appears?

The pane is the convenience, not the storage. When it does not appear, or you dismissed it, the files are still on disk and you can reach them two ways.

The documented route inside Excel is File > Open > Recover Unsaved Workbooks, at the bottom of the recent files list. That opens the folder Excel keeps for workbooks that were never saved to a real path — the hardest case, where a brand-new unnamed workbook was lost.

For a file that had been saved at least once, File > Info > Manage Workbook lists the autosaved versions belonging to that workbook, and you can open or restore any of them.

On Windows, the underlying folders live under your user profile in the Microsoft Office application data, in an UnsavedFiles folder and per-workbook AutoRecover folders. The exact path varies by Office version and by whether the file lives on OneDrive, so use the in-application routes above rather than memorising a path. If you do browse there, the files carry extensions such as .xlsb or .asd and open normally through Excel's File > Open dialog.

One caution about recovery files: there is normally only one recent autorecovered state per workbook, not a timeline. Opening the recovered version and then closing Excel again without saving can leave you with nothing, because the next clean exit is treated as confirmation that you no longer need it. Treat the first recovered copy you see as the only one you will get.

Check version history for cloud files

If the workbook is stored on OneDrive or SharePoint, there is a better copy than any recovery file: the service's own version history. Use File > Info > Version History, or open the file in the browser and use the version list there. That history is independent of whether Excel crashed, and it usually goes back much further than AutoRecover does.

This is the single strongest argument for keeping working files in a synced location. Version history turns a crash from a recovery exercise into a two-click rollback.

Knowing where the recovery files live is useful once a year. Knowing your reporting is sound is useful every week. Get a free audit.

How do you set Excel up so a freeze costs almost nothing?

Recovery settings only help if they were switched on before the crash. Check them now, not after.

Go to File > Options > Save. Microsoft documents two settings there that matter: Save AutoRecover information every x minutes, and Keep the last autorecovered version if I close without saving. Both should be ticked.

For the interval, Microsoft's own guidance notes the trade-off plainly: a short interval such as five or ten minutes limits how much work you can lose, while a longer interval such as twenty minutes may make Office run slightly faster. On any modern machine, choose the short interval. The performance difference is rarely noticeable; the difference between losing three minutes and losing twenty is not.

Turn on AutoSave for files kept in OneDrive or SharePoint. AutoSave is a different feature from AutoRecover: it writes your changes continuously to the cloud copy rather than keeping a separate recovery file, and it only works for files in those locations. A local file on your desktop cannot use it, which is the practical reason to stop keeping live work there.

One more thing worth knowing: Microsoft notes that AutoRecover saves your workspace where it can, so after a restart Excel tries to reopen your spreadsheets with the same layout and the same cells selected. That is why the recovered session often feels like you never left.

It is worth checking these settings on every machine you use rather than assuming they travel with your account. The AutoRecover interval and the autorecovered-version checkbox are local Office settings, so a laptop you set up two years ago and a new desktop can disagree. The two minutes it takes to confirm is the cheapest insurance in this entire article.

Deal with the cause, not just the symptom

A workbook that freezes repeatedly has a reason, and the usual suspect is an add-in. Start Excel in safe mode to test that: hold Ctrl while launching it, or run excel /safe. Safe mode loads without add-ins and customisations. If the workbook behaves there, disable add-ins under File > Options > Add-ins and re-enable them one at a time until the culprit shows itself.

Add-ins are worth understanding rather than just switching off, since some of them are the reason the workbook exists. Our guide to how to get the Data Analysis ToolPak in Excel walks through how Excel loads these components, which is the same mechanism behind most add-in freezes.

Beyond add-ins, the common causes are volatile formulas recalculating across hundreds of thousands of rows, external queries waiting on a slow source, and files opened directly from a network share or an email attachment rather than copied locally first. Switching calculation to manual under Formulas > Calculation Options while you build a heavy model removes the most common freeze entirely.

Fragile spreadsheets are usually a symptom of reporting nobody has redesigned in years. Get a free audit and see what to fix first.

When is restarting the wrong move?

Three situations call for patience or a different approach instead.

A long calculation or query is genuinely running. Restarting throws away the work and you will simply wait again from the beginning. Check CPU and disk activity before deciding.

The file is on a network share or a disconnected cloud path. The freeze may be the network, not Excel. Restarting without fixing the connection reproduces the problem, and in the worst case the save that follows writes a partial file over a good one. Confirm connectivity first, then save a copy locally.

A dialog is waiting for you somewhere off screen. A hidden message box — an overdue password prompt, a link-update question, a print dialog on a disconnected printer — blocks the interface exactly like a freeze. Cycle through windows with Alt+Tab, and check other monitors, before concluding Excel has hung.

A fourth, less obvious case: the workbook is fine and the problem is the printer, the mail merge target or an external link to a file somebody else has open and locked. Excel will wait on any of those indefinitely while looking exactly like a crash. Closing the other application, or disconnecting from the resource it is waiting on, often releases the window without a restart at all.

There is also a timing consideration. If AutoRecover is set to ten minutes and you know the last write was eight minutes ago, waiting two more minutes before forcing the close can mean the difference between recovering almost everything and recovering a version from before your last substantial edit. You cannot trigger an AutoRecover write manually, but you can avoid killing the process thirty seconds before one was due.

If a particular model is business-critical and heavy enough to freeze regularly, the real fix is usually structural rather than configurational: move the data out of the worksheet and into a proper data model or a database, and keep the spreadsheet as the presentation layer. That is a larger project than ticking a checkbox, but it is the only change that removes the freezes rather than softening their consequences.

How does this compare to the alternatives?

Recovery features are a safety net, not a backup strategy. It is worth being clear about what each option actually protects.

• AutoRecover protects against crashes and freezes only. It is not a version history, it is cleaned up after a successful save, and it keeps one recent state rather than a timeline.
• AutoSave (OneDrive and SharePoint only) protects against losing recent edits, because there are effectively no unsaved edits. It does not protect against a bad edit, since it saves your mistakes just as faithfully.
• Version history on OneDrive or SharePoint protects against both crashes and bad edits, and reaches back days or weeks. This is the closest thing to a real safety net.
• Manual copies — saving report-v3.xlsx beside report-v2.xlsx — still have a place for genuine milestones, such as a figure you reported externally and must be able to reproduce.
• Simply pressing Ctrl+S often remains the cheapest and most reliable habit of all, and it is the one that makes every other option on this list a formality.

For most people the right configuration is: files in OneDrive or SharePoint, AutoSave on, AutoRecover on at a short interval, and version history as the thing you actually reach for when something goes wrong.

The one combination to avoid is a local-only file with a long AutoRecover interval and no manual saving habit, which is also, unfortunately, the default state of a lot of working spreadsheets. Every mitigation above exists because that combination is the one that loses a day's work.

Final Thoughts

Restarting Excel without losing data is mostly a matter of not rushing. Wait for the application to come back on its own, attempt a save or a copy if it does, close it the gentlest way that works, and save the recovered version under a new name before you touch anything else.

Then spend the five minutes that prevents the repeat. Tick both AutoRecover boxes, set a short interval, move live working files to a synced location, turn AutoSave on, and run a safe-mode test if a particular workbook freezes more than once. A freeze becomes an interruption rather than a loss.

If spreadsheets are where your reporting actually lives, the fragility usually runs deeper than one frozen window — and it is worth reviewing the whole chain rather than hardening one file at a time.