Data in Cells are Missing when Saving Progress

Asked By Sarah Valdez 0 points N/A Posted on - 01/05/2012

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.

• Status: Open
• Question Views: 977
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By shamim006 0 points N/A #114218

Data in Cells are Missing when Saving Progress

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.

2. Office > Excel option> Formulas.

 

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

About shamim006

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/06/2012
• Question Category: MS Excel