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
- Related template: AccountsAdv IFRS, Charity/Academy, FRS101/102/105 LLP
- Software platform: Working Papers 2018, Working Papers 2019, Working Papers 2020, Working Papers 2021, Working Papers 2022