#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default excel formulas

my formulas aren't recalculating in excel. (i used to be able to copy and
paste and change numbers and it would recalc) the formula is correct when
you look at it but it will only calculate if you click on the formula again
in the input area and then hit enter.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default excel formulas

ToolsOptionsCalculation.

Set it to Automatic.


Gord Dibben MS Excel MVP

On Sat, 1 Dec 2007 08:43:00 -0800, bobbi
wrote:

my formulas aren't recalculating in excel. (i used to be able to copy and
paste and change numbers and it would recalc) the formula is correct when
you look at it but it will only calculate if you click on the formula again
in the input area and then hit enter.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
excel formulas Tomas Excel Worksheet Functions 19 February 20th 08 03:01 PM
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP Sherberg Excel Worksheet Functions 4 September 11th 07 01:34 AM
Copying formulas from Excel 2003 to Excel 2007 [email protected] Excel Discussion (Misc queries) 4 August 9th 07 06:06 PM
Formulas not evaluated, Formulas treated as strings Bob Sullentrup Excel Discussion (Misc queries) 0 November 27th 06 08:01 PM
Formulas in Excel XP Rebecca Excel Worksheet Functions 4 December 9th 05 04:52 PM


All times are GMT +1. The time now is 07:33 PM.

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

About Us

"It's about Microsoft Excel"