Forum Discussion
Circular rferencies
One way to find and fix circular references is to use the Trace Precedents and Trace Dependents commands on the Formulas tab in Excel.
These commands can help you visually trace the relationships between cells and identify the source of the circular reference.
Another way to find circular references is to use the Error Checking feature in Excel.
On the Formulas tab, click the Error Checking button, then select Circular References.
This will show you a list of cells that are involved in circular references.
If these methods don’t work for you, you might consider using a third-party add-in or tool that can help you find and fix circular references in your workbooks.
As far as I could gather from your text, you have already tried a few things...if none of this helped; you could try a third-party program to solve this.
One third-party tool that may be able to help you find and fix circular references in your Excel workbooks is PerfectXL. PerfectXL is capable of finding all types of circular references even before Excel itself highlights them . You can analyze your model and click the “Risk Overview” button to find them .
Standard Disclaimer: I provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.
I hope this helps!
HI, thanks for the tips but I have already try every possibility function from excel itself. Trace and circular function only function inside ONE workbook but not between two books.
best regards,
Conny 8877
My excel (365) do not shows circular references between two workbooks.
This is what I receive as message:
In between I have identified the two workbooks and try to find the faulty cell.
best regards
I am happy to tell You that I solve the problem with using PERFECTXL Risk Finder. I submit each of my excel files to the analyse of the Risk finder and I was astonished by the number of excel faults mentioned. This is a great tool and a very great help. After the corrections the problem disappears and I do not really know which was exactly the faulty cell(s).
In any case the number of dangerous and faulty formulas results were above my expectations. Growing for 23 years and passed through several excel versions my programs were instable and without this software I will never discover it.
By this way I thanks everyone who gives me hints and help and specially Mr Joel Steendam who provides me the Prefect XL programs.
This program should be in the computer of each one who use daily Excel.
Thank you all and greetings from Brugge in Belgium
- As I mentioned, "As far as I can gather from your text, you've already tried a few things...if none of those worked; you could try a third-party program to solve the problem."
I wish you success.Thank you for the tip, but after contacting a third party such as PerfectXL and they confess never had the problem and that there software's are only for stand alone workbooks.
I continue my investigations and if I succeed I wil tell the community.
Beste regards from Brugge (Belgium)
You could possibly do a repair, not sure if that will help, but it might be worth a try.
In the end, in order to be able to submit a precise solution proposal, it would make sense to look at the file (without sensitive data).Make a file without sensitive data from the existing file (delete all internal data and replace with imagery data), if the file repeats the problem, then it would still be possible to send it.
To be on the safe side, copy your original file and do the tests there.
If the problem does not recur, it means that there is a linked formula in some cell, as Mr.Sergei Baklan has already mentioned.Thank you for your patience and understanding
I know I don't know anything (Socrates)
