I'm not getting this one.
getting "Err:523" on this "=aug.F7+E7" just wanting to add value from F7 of another sheet to the value in E7 of current sheet.(yes within same document)
formula is in cell "F7" of current sheet.
is it creating a self-perpetuating circular reference or something?
[Solved] Error 523 on simple equation
[Solved] Error 523 on simple equation
Last edited by Hagar Delest on Thu Sep 26, 2013 7:54 am, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
ARKtik RUShin
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
Re: error 523 on simple equation
Sorry, I can't reproduce the problem: your formula works fine here and nothing I tried gave that error.
Can you attach a sample sheet that has the problem?
Can you attach a sample sheet that has the problem?
AOO4/LO5 • Linux • Fedora 23
Re: Error 523 on simple equation
here is a screen shot. i uninstalled then clean installed OO 4, same prob. very strange
thanx 4 help!
thanx 4 help!
ARKtik RUShin
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
-
- Volunteer
- Posts: 918
- Joined: Sun May 31, 2009 1:35 am
- Location: Sydney, Australia
Re: Error 523 on simple equation
From the list of Error Codes in OpenOffice.org Calc in Help, 523...
Function missed a targeted value, or iterative references do not reach the minimum change within the maximum number of steps set.
I can only assume that aug.F7 contains a formula that is responsible for the circular reference that does not converge.
Ken Johnson
Function missed a targeted value, or iterative references do not reach the minimum change within the maximum number of steps set.
I can only assume that aug.F7 contains a formula that is responsible for the circular reference that does not converge.
Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
[Solved]Re: Error 523 on simple equation
DUH!
thanks, just had to zero out an older sheet to give the loop a valid "value".
thanks again!
thanks, just had to zero out an older sheet to give the loop a valid "value".
thanks again!
ARKtik RUShin
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25