HomeTroubleshootingAll Products: Other IssuesWorkbook Recomputes Itself Periodically

3.15. Workbook Recomputes Itself Periodically

Applies to: All products

At regular intervals, my Excel freezes, then the cells all repaint themselves. Color cells disappear and then repaint themselves, too. During this, Excel is unresponsive but afterward everything seems fine.

Periodic actions sound like autosave. Saving a file triggers a recalculation, repainting cells and conditional formatting as numbers are recalculated.

Check your Autosave options by clicking File » Options » Save. If the AutoRecover file location is a network or cloud location, larger workbooks can take significant time to finish recalculating and saving themselves.

Consider changing the Autorecover file location to a local folder, such as your temp folder. To find your local folder, see Opening Your temp Folder.

Last edited: 2018-11-13

This page was: Helpful | Not Helpful