[Solved] Error 523 on simple equation

Discuss the spreadsheet application
Post Reply
User avatar
arktik
Posts: 15
Joined: Mon May 27, 2013 7:12 am

[Solved] Error 523 on simple equation

Post by arktik »

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) :D
formula is in cell "F7" of current sheet.
is it creating a self-perpetuating circular reference or something?
Last edited by Hagar Delest on Thu Sep 26, 2013 7:54 am, edited 1 time in total.
Reason: tagged [Solved].
ARKtik RUShin :crazy:
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: error 523 on simple equation

Post by acknak »

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?
AOO4/LO5 • Linux • Fedora 23
User avatar
arktik
Posts: 15
Joined: Mon May 27, 2013 7:12 am

Re: Error 523 on simple equation

Post by arktik »

here is a screen shot. i uninstalled then clean installed OO 4, same prob. very strange :evil:
thanx 4 help!
Attachments
prtScr1.jpg
ARKtik RUShin :crazy:
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
ken johnson
Volunteer
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: Error 523 on simple equation

Post by ken johnson »

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
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.
User avatar
arktik
Posts: 15
Joined: Mon May 27, 2013 7:12 am

[Solved]Re: Error 523 on simple equation

Post by arktik »

DUH!
thanks, just had to zero out an older sheet to give the loop a valid "value". :D
thanks again!
ARKtik RUShin :crazy:
Windows 7 / OpenOffice 4.0 / Java: Version 7 Update 25
Post Reply