I have gone into View, options, LibreOffice Calc, calculate and still nothing? This was brought over from Open Office because of problems with shutting down all the time and loosing my info and now this isn’t working. Frustarted!!!
Err 522 denotes a Circular Reference: Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - LibreOffice Calc - Calculate.
So I see no way other than to inspect the file and their formulas to analyze where the circular reference occurs. You could upload by editing your question and using the paper clip symbol.
Hello @Rock, ERR:522 will be shown in the cell in which Circular Reference takes place. For example, if in cell A1 you type
= A1 you will get the message ERR:522.
Add Answer is reserved for solutions.
Press edit below your question if you want to add more information.
There is a list of error codes in Help, here is a link to the page.