Forum Discussion
Calculation Result Error
Hello, in a very basic spreadsheet, when I a) copy a formula from one cell to the adjacent cell, the 'calculated' value is $0 or b) if I manually enter the formal into the adjacent cell, the 'calcu...
On the Formulas tab of the ribbon, in the Calculation Options group, make sure that Automatic is selected in the Calculation Options drop-down.
Also, check whether the status bar at the bottom of the window mentions Circular References.
Thanks Hans. It was a circular reference error. I learned something new. Regards, Claus