Automatically updating Less than or equals to

[bridge4444]

Can anybody tell me why a formula would not automatically update? Possible problem is in relation to "<=" component of formulas'. NOTE: This is not in relation to calculations option being set to 'Manual'.

This problem only effect two cells on my entire workbook and all other cells within the column affected, with the exact same formula, work fine.

The "<=" part of the formula is in relation to a drop down list with values from 1 to 12 and the formula works fine initially when flicking between the dropdown list numbers. But if I save the workbook on dropdown list number 2, the formula no longer works...


Can anybody help????

[Punnam]

HI

Sample workbook

Punnam