![]() |
|
#1
|
|||
|
|||
|
All of a sudden my Microsoft Excel formulas will not function within a file. Does anyone have an idea how to correct this? Thanks
|
|
#2
|
||||||||||||
|
||||||||||||
|
Is it just one file or all files ?
__________________
My System: Home Build
|
|
#3
|
|||
|
|||
|
this is all files. what will happen, when within a formula, I make a change and it does not immediately calculate. Then when I save the file, the calculation is then made. This is the same even in new files that I create.
|
|
#4
|
|||
|
|||
|
Check under Tools/Options click the Calculation Tab and make sure Calculation is set to Automatic.
|
|
#5
|
|||
|
|||
|
Philthomas, You are a genius. That was my problem. Thanks so much for your imput! I really appreciate your help.
|
|
#6
|
|||
|
|||
|
You're welcome ..... wish they were all as easy
|