Forum Discussion
Circular Reference when opening.
When opening my excel file, I get a circular reference Warning. I click "OK" and it finishes opening. I go to "Formulas/Error Checking" and circular references is greyed out indicating there a...
Thank you VERY much for your time and diagnosis. I realize it's a very complicated file with many references to other references and other sheets and contains many formulas.
I've been working on it for 5 years and making changes as I go, as needed, as well as constantly trying to optimize it and avoid volatility wherever possible. It's quite possible that the problem lies in an area where formula or structure has been changed over from a previous idea to a new one.
My knowledge of Excel is... somewhat of an advanced level of basic. Lol.
You've definitely helped immensely though in finding where problems lie as well as how to detect them. The VBA error was something I had tried out at one time but couldn't get it to work how I wanted. I don't use it at all and as such, have removed the module now.
I'll take the information you've given me and see if I can fix the errors. It might take a few days due to lack of time but I'll update you on the results.
Once again, Thank you so much, Sir!
I've been working on it for 5 years and making changes as I go, as needed, as well as constantly trying to optimize it and avoid volatility wherever possible. It's quite possible that the problem lies in an area where formula or structure has been changed over from a previous idea to a new one.
My knowledge of Excel is... somewhat of an advanced level of basic. Lol.
You've definitely helped immensely though in finding where problems lie as well as how to detect them. The VBA error was something I had tried out at one time but couldn't get it to work how I wanted. I don't use it at all and as such, have removed the module now.
I'll take the information you've given me and see if I can fix the errors. It might take a few days due to lack of time but I'll update you on the results.
Once again, Thank you so much, Sir!
Immortalis wrote: ``I'll take the information you've given me and see if I can fix the errors. It might take a few days due to lack of time but I'll update you on the results.``
I would appreciate that.
I finally got around to working on the problem. Your trace of the "Aug" circular references was the key factor. It indeed was an overlap between old formulas and new ones I had implemented and because everything references everything, fixing one circular reference created another. I had to repair about 10 of them to clear them all and I no longer get the warning when opening my spreadsheet.
Thank you so very much!