Circular reference in excel.

Question

Circular reference in excel.

Peggy Capson 0

How do I delete a circular reference in excel so that a solumn of amounts will add correctly?

Alexis-NG 16,710 Reputation points Microsoft External Staff Moderator

2026-06-11T17:26:11.4466667+00:00

Hi @Peggy Capson,

I hope everything is going well on your end.

I am following up on the support thread that has been discussed and wanted to check whether the information shared in my previous response helped address the issue you were experiencing.

If you are still encountering any issues or have additional questions, please feel free to reach out at any time. I would be happy to assist further as needed.

Additionally, ensuring that everything is functioning as expected and that your experience remains smooth is a top priority.

Thank you again for your collaboration throughout the troubleshooting process. I look forward to hearing from you soon.

1 answer

Your answer

Alexis-NG 16,710 Reputation points Microsoft External Staff Moderator

2026-06-11T17:26:11.4466667+00:00

Hi @Peggy Capson,

I hope everything is going well on your end.

I am following up on the support thread that has been discussed and wanted to check whether the information shared in my previous response helped address the issue you were experiencing.

If you are still encountering any issues or have additional questions, please feel free to reach out at any time. I would be happy to assist further as needed.

Additionally, ensuring that everything is functioning as expected and that your experience remains smooth is a top priority.

Thank you again for your collaboration throughout the troubleshooting process. I look forward to hearing from you soon.

Answer 1

Hi @Peggy Capson,

To resolve this issue, please follow these steps:

Go to the Formulas tab in Excel.
Click on Error Checking > Circular References.
Select the highlighted cell from the list (e.g., D1). Excel will automatically take you directly to the cell that contains the issue.
Once redirected, review the formula and either modify the formula to remove the self-reference, or delete the formula if it is not needed

After correcting or removing the formula, the error should be resolved.

I hope this provides enough clarity and helps you stay inform with your current situation.

In the meantime, if you see my replies bring helpful information, please kindly accept it as an answer and vote it up by your original account, which raised this question. Once marked, it will automatically pin to top. As other users will also search information in this community, your valuable vote up will definitely also help other users who have similar queries easily to find the correct channel and useful information more quickly.

Thank you for your understanding. If you need assistance adjusting the formula or identifying the correct calculation logic, please feel free to share more details, and I will be happy to help further.

Note: Follow the steps in this documentation to enable email notifications if you want to receive email notifications related to this topic.

Share via

Circular reference in excel.

1 answer

Your answer