I was getting this circular reference error in my Excel application. So I can tell you how I have fixed this error in Excel.
Well, this particular circular reference error occurs when the formula either directly or indirectly refers to the cell in which it is already contained. Due to this, the formula starts calculating the already obtained result which leads to generating this type of error.
Give it a try at all the fixes listed in this post. I found this article very helpful as the listed solution worked in my case.