Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

[SOLVED] Excel formula not updating

This is a discussion on [SOLVED] Excel formula not updating within the Microsoft Office support forums, part of the Tech Support Forum category. Several of my accounting staff have reported a strange problem. The other day two of them were working on Excel


Closed Thread
 
Thread Tools Search this Thread
Old 06-21-2007, 06:46 AM   #1
Registered Member
 
Join Date: Aug 2005
Posts: 100
OS: XP Pro



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.

__________________
kurtismonger is offline  
Old 06-21-2007, 11:57 AM   #2
Team Manager, Articles
Analyst
Rangemaster, TSF Academy
 
Glaswegian's Avatar
 
Join Date: Sep 2005
Location: Glasgow
Posts: 38,400
OS: Win XP Pro SP3 / Win 7 Pro

My System


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.

__________________
Iain - Defender of the Haggis and all things Scottish.
I don't help by PM - post in the Forums.



PC Safety & Security::PC running a bit slow?::Photographers Corner
Glaswegian is offline  
Old 06-07-2009, 03:59 PM   #3
Registered Member
 
Join Date: Jun 2009
Posts: 1
OS: XP



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.
__________________
TyWebb is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula over multiple sheets
Hi, I want to make formula in excel but the data is spread over multiple sheets, how can that be accomplished? Thanks, Just me.
spxtechsupport Microsoft Office support 5 05-16-2008 03:27 PM
formula for excel
Does anyone know if there is a way to make an excel spreadsheet template that when I open a new xls based on that template will generate a number and then remember that number so that the next time I open a new xls based on the template it will generate the next number in sequence ??
vampyr2005 Microsoft Office support 22 01-11-2007 12:07 PM
Excel formula question
I am making some charts. I have all my formulas correct for my cells. The only cell that I am having problems with is: Example: I need to figure the formula for cost + 20%. ???? =sum(d3+20%) I know the formula I just showed is incorrect but its an idea of what I need. Can anyone help.
roadwarrior Microsoft Office support 2 08-28-2006 05:31 AM
pop ups, system slow down
Hi, thanks for reading my log. I have a big problem with pop ups. I use add aware and spybot. Any suggestions. I have a hijack this log to help. Logfile of HijackThis v1.99.0 Scan saved at 8:07:06 AM, on 8/25/2005 Platform: Windows XP (WinNT 5.01.2600) MSIE: Internet Explorer v6.00...
eric22md Inactive Malware Help Topics 60 09-15-2005 12:01 AM
Help Getting Ratio Formula Excel
I need some help getting an Excel ratio formula. These are the numbers: 108 (supply - available appointments) 181 (demand - patients calling for the appointments) 12 sessions (Doctors)
texboy Microsoft Office support 0 02-11-2005 11:58 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2


All times are GMT -7. The time now is 05:06 PM.


Copyright 2001 - 2014, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts