Select “Manual’ option and uncheck “Recalculate Workbook Before Saving” check box.
Under “Calculation Options” section, you can find “Workbook Calculation” options.
Go to “File > Options” menu and navigate to “Formulas” section.
It’s advisable to enable Manual Calculation, so there’s no effect on the overall performance. One solution is to disable the Automatic Workbook Calculation option. The performance will suffer further if you add lot of images, such as product images. You should know that when you add something to the spreadsheet, Excel will recalculate all formulas. Eventually, the performance will slow down noticeably. If you use your spreadsheet to record new information on daily basis, you may continue to add rows, columns and formulas. Open the file again and check whether the performance is improved.
Go to “File > Save” and close the file.
Press “Win + R” key shortcut to open Run prompt.
You should pinpoint what’s happening with the program using safe mode. If Excel performs slowly with any file, then the problem could be related with Excel itself. You need to check whether Excel performs very slowly when opening a particular file, a few files or all files. Related: Fix Slow Microsoft Word Issues to Speed Up Your Work. Microsoft Excel White Screen of Death Fix Slow Microsoft Excel and Speed Up Spreadsheet Processingĭepending on the issue and situation, you can follow one of the below option to fix your Excel workbook.
0 kommentar(er)
