Everytime I save the file and close it, the =MOD function is changed to MODE.SNGL upon the next opening which ruins all the formulas in the sheet. Why is this happening and how to prevent it?
Exact formula:
=IF(MOD(ROW();8)=1;INDEKS(D:D;(ROW()+7)/8);"")
formula that prints every 8 cell value from collumn D in every cell in collumn A
it changes to:
=IF(MODE.SNGL(ROW();8)=1;INDEKS(D:D;(ROW()+7)/8);"")
next time I save and re-open the file
thank you.
