[SOLVED] Excel formula not updating

kurtismonger · 06-21-2007, 07:46 AM

Several of my accounting staff have reported a strange problem. The other day two of them were working on Excel spreadsheets and when they updated an amount in one cell, the formula that added up a range of cells, including the one they changed, did not update. I couldn't duplicate the problem but they said they checked the formula, made sure they clicked off the updated cell, even saved the spreadsheet, etc. These are experienced Excel users so I trust they know what they are doing.

To further complicate things both users were working on different spreadsheets under different versions of Excel (one on Office 2003, one on 2007).

The only common thing between them is that both spreadsheets were opened from our shared network drive. I thought it might be related to loss of network connection, but both said they were able to save the spreadsheets back out to the network. The following day when I looked at the spreadsheets, the formulas were working fine and updating as values changed.

**Glaswegian** · 06-21-2007, 12:57 PM

Quote:

These are experienced Excel users so I trust they know what they are doing.

Trust no-one and nothing unless you've seen it with your own eyes - honestly - I've seen "experienced" users do the strangest things...

This sounds as though Calculation had been set to Manual rather than Automatic. Hitting F9 will force Excel to re-calculate. Or change the setting via Tools > Options > Calculation tab.

TyWebb · 06-07-2009, 04:59 PM

Click the "Office Button" In excel and choose "Excel options". Under the "formulas" tab there is an option for "workbook" calculation, make sure "automatic" is chosen.

06-21-2007, 07:46 AM	#1 (permalink)
kurtismonger Registered User Join Date: Aug 2005 Posts: 83 OS: XP Pro	[SOLVED] Excel formula not updating Several of my accounting staff have reported a strange problem. The other day two of them were working on Excel spreadsheets and when they updated an amount in one cell, the formula that added up a range of cells, including the one they changed, did not update. I couldn't duplicate the problem but they said they checked the formula, made sure they clicked off the updated cell, even saved the spreadsheet, etc. These are experienced Excel users so I trust they know what they are doing. To further complicate things both users were working on different spreadsheets under different versions of Excel (one on Office 2003, one on 2007). The only common thing between them is that both spreadsheets were opened from our shared network drive. I thought it might be related to loss of network connection, but both said they were able to save the spreadsheets back out to the network. The following day when I looked at the spreadsheets, the formulas were working fine and updating as values changed.

06-07-2009, 04:59 PM	#3 (permalink)
TyWebb Registered User Join Date: Jun 2009 Posts: 1 OS: XP	Re: [SOLVED] Excel formula not updating Click the "Office Button" In excel and choose "Excel options". Under the "formulas" tab there is an option for "workbook" calculation, make sure "automatic" is chosen.