How to Open Excel in Safe Mode in Windows

Other Interesting Articles

Method 5: Using Registry Editor

The fifth and final way to open Excel in safe mode is to use Registry Editor. Registry Editor is an application that lets you view and change system settings stored in the Windows registry. The registry is a database that stores information about hardware, software, and user configurations in Windows. Changing the registry can be risky, so make sure you make a backup before doing so. Here’s how:

  1. Close all running Excel applications.
  2. Press the Windows and R keys at the same time to open the Run dialog box.
  3. Type regedit in the text box and press Enter or click OK. You may be asked to enter your password or confirm your choice.
  4. In the Registry Editor window, navigate to the following folder:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options

Note: The number 16.0 may differ depending on the version of Excel you are using. You can check it in the Help menu > About Excel.

  1. Right-click on the Options folder and select New > DWORD (32-bit) Value.
  2. Name the new value NoReReg and press Enter.
  3. Double-click on the NoReReg value and change its value data to 1. Click OK.
  4. Close Registry Editor and open Excel. Excel will open in safe mode.

Tips and Tricks to Optimize Excel Performance

After you successfully open Excel in safe mode, you can try some of the following tips and tricks to optimize your Excel performance:

  • Check if any add-ins are problematic or incompatible with your Excel. You can do this by opening the File menu > Options > Add-Ins. There, you can see a list of active, inactive, or available add-ins. You can try disabling or removing add-ins that you don’t need or that are suspicious.
  • Check if there are any corrupted or invalid files interfering with your Excel. You can do this by opening the File menu > Open and looking for a file that has an extension.xlsb,.xlsm,.xltm, or.xlam. These files are binary, macros, templates, or add-ins that may contain unsafe or malfunctioning code. You can try moving or deleting these files from your Excel default location.
  • Check if there are any incorrect or inappropriate settings with your Excel. You can do this by opening the File menu > Options and reviewing the different categories of settings, such as General, Advanced, Formulas, Save, Trust Center, and more. You can try to restore the settings to their defaults or change settings that might be causing the problem, such as Enable iterative calculation, Disable hardware graphics acceleration, Disable AutoRecover, or Block macros from running in Office files from the Internet.
  • Check if there are any updates available for your Excel or Windows. You can do this by opening the File menu > Account > Update Options > Update Now for Excel or the Start menu > Settings > Update & Security > Windows Update > Check for updates for Windows. You can try installing available updates to improve stability.

How to Exit Safe Mode

After you finish using Excel in safe mode, you may want to return to normal mode. There are several ways to exit safe mode, depending on how you open Excel in safe mode. Here’s how:

  • If you open Excel in safe mode by using keyboard shortcuts, Command Prompt, or Task Manager, you can simply close Excel and reopen it as usual.
  • If you open Excel in safe mode by using a desktop shortcut, you can simply remove the shortcut from your desktop and open Excel from its original location.
  • If you open Excel in safe mode by using the Registry Editor, you must change the value of NoReReg back to 0 or delete it from the registry. You can follow the same steps as described in way 5 but with different value data.

Latest Articles

Related Articles