Excel crashes on microsoft

Question

Everytime i make any change and go to another window(tab) it crashes. If I just make a change it will eventually just crash.The whole excel is very slow, if i go from one to another tab on excel it becomes very very slow. very annoying.

Answer 1

Hi, thank you for replying. I recommend uninstalling the Office and reinstalling it.

To Uninstall:

https://www.matabaro.co.uk/it-snipits-home/how-to-repair-microsoft-office-on-an-apple-mac-mac-book/

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

To Reinstall:

https://support.microsoft.com/en-us/office/download-install-or-reinstall-microsoft-365-or-office-2024-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658#installsteps=install_on_a_mac

Answer 2

Hi, I'm Bernard, a fellow Windows user. I'm happy to help!

This issue occurs when there is a miscalibration in your Excel. In this case, kindly follow the steps provided by Q&A Assist. However, if the issue persists, I recommend repairing Microsoft Office on your PC. Kindly follow the steps below:

 

Press the Windows key + R, then type in:

 

appwiz.cpl

 

Then hit OK

 

Look for the Microsoft Office or Microsoft 365 app > Right-click, then select "Change" > Select "Quick Repair" Then follow the prompts to repair.

Answer 3

If Excel is crashing frequently and running slowly, there are several potential causes and solutions you can explore:

1. Temporary Files: Accumulation of temporary files can slow down Excel and cause crashes. You can clean out temporary files by accessing the Temp directory. On Windows, you can do this by typing %temp% in the Run dialog (Win + R) and deleting unnecessary files.
2. Large Number of Controls: If your workbook contains a large number of controls (like checkboxes or hyperlinks), it can slow down performance. Consider redesigning your workbook to reduce the number of controls.
3. Virus Scanner Settings: Some settings in your virus scanner can interfere with Excel's performance. Try temporarily disabling your virus scanner to see if it improves performance.
4. Tracking Changes in Shared Workbooks: If you are tracking changes in a shared workbook, this can increase the file size and slow down performance.
5. Used Range Problems: Oversized used ranges can cause slow performance. Make sure there are no hidden rows or columns that are unnecessarily large.
6. Online Repair: If the issue persists, consider performing an Online Repair of Microsoft Office. This can fix corrupted components. To do this, go to Settings > Apps > Installed apps, find Microsoft 365, click on the three dots, select Modify, and choose Online Repair.

After trying these solutions, restart your computer and check if the issue with Excel persists. If it does, you may need to consider moving to a 64-bit version of Excel or breaking your workbook into smaller files.

---

References:

• Excel performance: Tips for optimizing performance obstructions
• How to clean up an Excel workbook so that it uses less memory