Circular Reference

[LipChean_Soh]

Hi,

I'll pm you.

Thanks,

LipChean

[peggyhai]

thanks  a lot.

You will PM me via Skype?   What time?   As it is 7:38pm in HK now.   I am very hungry

[LipChean_Soh · Accepted solution]

Hi,

For the folks out there, the circular reference happened during a module creation, because of an error in Standard Version formula, i.e. Forecast = Actual - Forecast.

The circular reference error didn't happen during the Standard Version formula processing, but during the creation of a module involving standard Version.

Thanks,

LipChean

[AlejandroGomez]

Great job @LipChean_Soh LipChean!  Thanks for sharing it. 

I hope @peggyhai  managed to have dinner in time! haha. 

[edwards142]

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.

source: fix circular reference error