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?
formula that prints every 8 cell value from collumn D in every cell in collumn A
it changes to:
next time I save and re-open the file
Can you attach (part of) your file without sensitive data? I am unable to reporduce the problem.