Excel warning message - There are circular references where a formula refers to to its own cell directly or indirectly

Question

When I open Excel file with the extension as .xlsb getting Message as There are circular references where a formula refers to to its own cell directly or indirectly. I changed the date format from dd-mm-yy to dd-mm-yyyy in Masterdata, where this date was in few different sheet . Is it causing the issue. Pls suggest How to get rid of this message.

Answer 1

Refer to the following Microsoft Link on Circular references and follow the guidelines to identify the cell/s containing circular references and take corrective action.

https://support.microsoft.com/en-au/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123

Answer 2

Thanks..resolved the issue

And thanks to you for the message. I am happy to have been able to assist.

Answer 3

Thanks..resolved the issue