If you happen to can’t close an Excel worksheet on Windows 11/10, the options supplied on this article will enable you to repair the issue. In accordance with the customers, after they click on on the pink cross button on the highest proper aspect, Excel gained’t close. Some customers obtained error messages whereas closing the Excel file, whereas, for some customers, nothing occurs after they click on on the close button. There could be a number of causes of this challenge. Let’s discuss in regards to the attainable options.

The error messages that some customers obtained whereas closing Microsoft Excel are:

Microsoft Excel is trying to find an answer.

Microsoft Excel is ready for one more software to finish an OLE motion.

Cannot close Excel on Windows 11/10

If you happen to can’t close Excel on your Windows 11/10 PC, use the options supplied under to repair the difficulty:

  1. Power close Excel and restart it
  2. Set up Workplace updates
  3. Open Excel in Secure Mode
  4. Change your default printer
  5. Add a Close button
  6. Carry out a web-based restore
  7. Uninstall and reinstall Workplace

Let’s see all these fixes intimately.

Excel gained’t close when clicking “x” button

1] Power close Excel and restart it

You need to use the Process Supervisor to power close packages. Close Excel through the use of the Process Supervisor and restart it. Earlier than continuing, save your work. Undergo the next directions:

  • Open the Process Supervisor.
  • Choose the Processes tab.
  • Proper-click on Microsoft Excel and choose Finish process.

After force-closing Excel, open it once more and see if the difficulty persists.

2] Set up Workplace Updates

Outdated purposes could comprise bugs on account of which customers expertise points. Just be sure you are utilizing the newest model of Microsoft Workplace. Test for Workplace updates manually. If updates can be found set up them.

3] Open Excel in Secure Mode

It is usually attainable that an add-in is interfering with Excel and stopping it from being closed. To verify this, open Excel in Secure Mode. In Secure Mode, some add-ins stay disabled. If the issue doesn’t happen in Secure Mode, one of many put in add-ins is the perpetrator. Now, close Excel and open it in regular mode. Now, disable the put in add-ins one after the other to establish the problematic add-in. The next steps will enable you to with that:

  1. Open Excel in regular mode.
  2. Open an current file or create a brand new one.
  3. Go to “File > Options > Add-Ins.”
  4. Choose COM Add-ins within the drop-down and click on Go.
  5. Uncheck one of many accessible add-ins to disable it and click on OK.
  6. After disabling every add-in, close the Excel file.

Repeat the above-mentioned steps till you discover the problematic add-in. As soon as you discover the problematic add-in, take away it and discover its various.

4] Change your default printer

In accordance with the reviews, altering the default printer labored for a lot of customers. You also needs to do this and see if it helps. Generally, Microsoft Workplace purposes are unable to entry the default printer on account of which customers can expertise a number of points. On this case, altering the default printer can repair the issue.

Change your default printer and choose Microsoft XPS Doc Author as your default printer. It ought to work. If Microsoft XPS Doc Author is lacking on your laptop, you must set up it through the Elective Options. The next directions will enable you to with that:

  1. Open the Management Panel.
  2. Choose Class within the View by mode.
  3. Go to “Programs > Programs and Features.”
  4. Click on on the Flip Windows options on or off hyperlink on the left aspect.
  5. Within the Windows Options, choose the Microsoft XPS Doc Author checkbox and click on OK.

The above steps will set up Microsoft XPS Doc Author on your system. After putting in it, it is possible for you to to set it as your default printer.

5] Add a Close button

If you happen to can’t close Excel by clicking on the pink cross button on the highest proper aspect, you may add a Close button on the Excel ribbon to close your Excel recordsdata. The next steps will information you on learn how to add a Close button on the Excel ribbon.

  1. Open Microsoft Excel.
  2. Open an current file or create a brand new one.
  3. Go to “File > Options.”
  4. Choose the Customise Ribbon class from the left aspect.
  5. Choose Primary Tabs within the drop-down below the Customise the Ribbon part.
  6. Choose Dwelling and click on on the New Group button accessible on the backside.
  7. Choose the newly created customized group and rename it (in order for you) by clicking on the Rename button on the backside. I renamed it Close.
  8. Now, choose All instructions within the drop-down below the “Choose commands from” part on the left aspect.
  9. Scroll down and choose Close.
  10. Click on Add so as to add the Close button within the customized group you created.
  11. Click on OK to save lots of the modifications.

The above steps will add the Close button within the Dwelling tab on the Excel ribbon (see the above screenshot). Now, everytime you click on on this Close button, Excel will close the presently opened file. Do observe that this button won’t close the whole Microsoft Excel app.

6] Carry out a web-based restore

If the issue nonetheless persists, we propose you restore Microsoft Workplace. Working a web-based restore is useful when Workplace purposes begin giving points and errors. The method will take a while as a result of Microsoft Workplace downloads the required recordsdata to restore this system.

7] Uninstall and reinstall Workplace

If not one of the above fixes helped, uninstall Microsoft Workplace and set up it once more. Earlier than you proceed, just be sure you have the Workplace activation key. You’ll require this key to activate Workplace after putting in it once more. This could assist.

Learn: Can’t kind numbers or enter knowledge into Excel cell.

How do I repair Excel not responding in Windows 11?

If Excel freezes, crashes, or stops responding, the issue could be related to a third-party add-in. It is best to begin Excel in Secure Mode and see if the difficulty persists. Additionally, guarantee that the Microsoft Workplace software is updated. Outdated software program could trigger some points on account of bugs.

Why is Excel not letting me close?

In case you are not capable of close Microsoft Excel, first, see if Excel is displaying an error message whereas closing it. If sure, troubleshoot it accordingly. If you happen to click on on the pink cross button on the highest proper aspect however Excel gained’t close, you must verify if the issue is going on on account of an add-in or not. For this, you must begin Excel in Secure Mode. Different fixes that you may attempt to repair the difficulty embody updating Microsoft Workplace manually, repairing Microsoft Workplace, uninstalling and reinstalling Workplace, and so on.

Learn subsequent: Arrows keys not working in Microsoft Excel.



Source link

Share.
Leave A Reply

Exit mobile version