Question

Saira is having a crisis. For some reason she cannot find a number of products that she knows for a fact she has entered with their details in the worksheet. She has not deleted anything either. Where could have data gone?

Answer 1

Unfortunately, if the power goes out or you accidentally choose “No” when Excel prompts you to save the file, entered but unsaved data disappears from the spreadsheet. Turning on the AutoSave or AutoRecover feature can help recover some data. This feature periodically saves entered data without being prompted.