It may be a real virus that could cause harm to your computer.

Even a 30 seconds delay can hurt the flow of your job, especially if you need to open and close spreadsheets regularly.

In a more serious situation, Excel may freeze for a long time and a Not Responding message is shown on the top of the window.

If Excel performs slowly with any file, then the problem could be related with Excel itself.

When opened in safe mode, you will see the Safe Mode in brackets along with the name of the Excel spreadsheet.

If the problem still occurs, choose the Online Repair feature.

The copy should become your backup, in case something goes wrong.

If the spreadsheet has multiple tabs, you should repeat the step to clear rules.

Open the file again and check whether the performance improves.

You should know that when you add something to the spreadsheet, Excel will recalculate all formulas.

The performance will suffer further if you add lot of images, such as product images.

One solution is to disable the Automatic Workbook Calculation option.

Its advisable to enable Manual Calculation, so theres no effect on the overall performance.

If values in some parts of your spreadsheet are static, it doesnt make sense to continue using formulas.

This is a very effective method, but can be complicated sometimes.

All calculations and processes of raw input data can be performed separately, depending on the requirements.

You need to do this carefully, especially if there are complex calculations.

However, issues may arrive when you double click the spreadsheet file directly, without opening Microsoft Excel first.

Superfetch works based on cached data on the RAM, so the file can be fetched very fast when necessary.

At certain point, the file can become unstable and crashes are more likely to happen.

The best way is to do it manually, by removing unnecessary formulas and formatting.

This will be in XLSM format and will be very slow compared to simple XLSX fie formats.

So only use macro enabled format when there are macros inside Excel.

When you enable data connections ignoring the warning, Excel will take long time to open the file.

Memory Slow For Excel Mac