I am receiveing err522, what do I do?

asked 2020-10-29 18:32:25 +0200

Rock gravatar image

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!!!

edit retag flag offensive close merge delete

Comments

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.

Opaque gravatar imageOpaque ( 2020-10-29 18:45:50 +0200 )edit

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.

LeroyG gravatar imageLeroyG ( 2020-10-30 00:11:36 +0200 )edit

There is a list of error codes in Help, here is a link to the page.

Earnest Al gravatar imageEarnest Al ( 2020-10-30 02:46:45 +0200 )edit