Data in Cells are Missing when Saving Progress

Asked By 0 points N/A Posted on -
qa-featured

I have an Excel spreadsheet which requires a large a number of cells to be filled in with important data’s. For some reasons, every time I save my progress, the important data in the cells are missing. Is there another way to prevent it from being saved until all the cells are filled in?

I am only a novice when it comes to using Excel, so any guide or any form of help you can give would be very helpful.

Also, if you think there’s something wrong with the way I do my work, please point it out to me. I’d love to hear all of your opinions regarding this.

Thanks a lot.

SHARE
Answered By 0 points N/A #114218

Data in Cells are Missing when Saving Progress

qa-featured

Normally when we complete an entry it calculate a formula and automatically recalculate the existing formulas for their data changes, this is done for small worksheets.

But for a complex model that takes much more time to recalculate.

This automatic recalculation can be off at Excel 2007.

1. Formula > Calculation option.

This automatic recalculation can be off at Excel 2007

2. Office > Excel option> Formulas.

step to open excell in microsoft office

 

recalculate by pressing F9 for open worksheet and Shift + F9 for active worksheet

You can recalculate by pressing F9 for open worksheet and Shift + F9 for active worksheet.

Login/Register to Answer

Related Questions