Cyclic Calculation Error

Cyclic calculation errors usually occur when a note's calculation has been amended in some way.

To correct this, locate the note which contains the problem cell and run a Remove and Replace.

The reference in the error message relates to the note (refer to the list of common references below to help identify the location to remove and replace). 

In our example, the cell references in the above picture relate to the Balance sheet, as these begin BS1. 

It is worth noting that the third character in the reference can vary depending on the table layout loaded.

For example, the reference FN3 may still refer to the Financial instruments note. 

Use the Technical Support Information button on the Help toolbar to identify cell references.

List of Common References:

FN1 – Financial instruments

CF2 – Cashflow statement

OP1 – Operating Profit

PEC – Pension commitments

BS1 – Balance sheet

FAI – Fixed Asset Investment

TA1 – Tangible fixed asset

ST1 - Employees note

CT0 – Taxation note

OC2 – Profit and Loss account

XX1 – Inserted notes (any reference beginning XX or XW is relating to an inserted note)

CC0/CC1 - Capital Commitments Note

LBE - Company Balance sheet

RE2 - Statement of Income and Retained Earnings