Circular Reference

LipChean_Soh
Certified Master Anaplanner

Re: Circular Reference

Hi,

 

I'll pm you.

 

Thanks,

LipChean

peggyhai
New Contributor

Re: Circular Reference

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
Certified Master Anaplanner

Re: Circular Reference

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
Master Anaplanner/Community Boss

Re: Circular Reference

Great job @LipChean_Soh LipChean!  Thanks for sharing it. 

 

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

edwards142
Not applicable

Circular Reference error in excel.

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