Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > updating formulas
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 15
Default updating formulas
I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,651
Default updating formulas
Tools/ Options/ Calculation:
set to Automatic.
--
David Biddulph

"Charlotte" wrote in message
...
I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?


Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,101
Default updating formulas
Goto Tools|Options|Calculation
Make sure Automatic is selected and not manual

"Charlotte" wrote:

I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?
Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 15
Default updating formulas
Ok, thanks, so how do you set to automatic? I am not sure about this. Thanks

"David Biddulph" wrote:

Tools/ Options/ Calculation:
set to Automatic.
--
David Biddulph

"Charlotte" wrote in message
...
I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?



Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 15
Default updating formulas
I got it thanks so much

"David Biddulph" wrote:

Tools/ Options/ Calculation:
set to Automatic.
--
David Biddulph

"Charlotte" wrote in message
...
I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?



Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas aren't updating ANTHER Excel Worksheet Functions 2 May 26th 07 06:36 PM
Formulas not Updating Joe A Excel Discussion (Misc queries) 0 May 24th 06 04:18 PM
Updating formulas craftcenter Excel Worksheet Functions 3 March 31st 06 12:50 AM
formulas not updating john_mc Excel Discussion (Misc queries) 0 March 1st 06 12:47 AM
Formulas Not Updating!!! carlyman Excel Discussion (Misc queries) 3 September 22nd 05 11:42 PM


All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement