Excel formula not updating
As you know, the arguments of Excel functions are entered within the parentheses.In complex formulas, you may need to enter more than one set of parentheses, one within another, to indicate the order in which the calculations should take place.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.
To change this, open the workbook, select the "Formula" tab (Alt M), then click "Calculation Options" and the select "Automatic". I think this can happen when you end up with different data types in the fields in the given range. The formula is: Everything else is updating in the spreadsheet. The value displayed is the value before I updated the information on Main Copy.