Current Behaviour
: While the root cause of how duplicate sheet references arise has not yet been fully addressed, a change has been made to allow affected calculations to open and save successfully. Where duplicate sheet references are detected, the system automatically assigns a disambiguating suffix to the duplicates (for example, a sheet reference D8 appearing twice would result in D8 and D8_DUP, or D8_DUP and D8_DUP1 for further duplicates). Users are notified of this with the following message: "Some duplicate sheet references were updated (e.g., D13_DUP) to prevent open/save issues. Please review and rename them if required, and save the calculation to retain these changes." Users are encouraged to review and rename any such sheets as appropriate and save the calculation to retain the changes.