Formula does not update automatically

Hi Everyone,

I have a problem with the updating the data of my excel sheet. In case I press F9 to update, certain formulas of cells get deleted. The first column is defined as:

1. = Left(E28;5)
2. = SRCDBSUM(FY$12;$I$18&$I$19&" and Prod='"&$E87&"'")*FY$16*FY$17

Both formulas refer to products which are defined in column E. The strange thing about it is, that as long as the formula refers to the major product desciption it does not get deleted. Only if it refers the products listed, they disappear.

Thanks for helping,

Franziska

Hi, it is SRCDB and SUM

okay....thanks for trying to help anyways