Forum Discussion
Circular rferencies
Hi,
I have 4 excel workbooks which are inter-relate, exchanging data from each other. Since a few days, excel reports a circular reference in between two of the the workbooks and tells me that he can’t show me the failure. I am searching since several days after this fault but can’t find it. Excel is working very slow and practical unusable. Is there a way to find such a fault?
NB: each workbook is between 20 and 60 Mbytes, and I have a I7 processor last generation with 64 ram and a SSD of 1T byte.
I already try every possibility of Excel, including the circular references options in the checking errors list. Excel answer is always the same "he is not able to show the cells that are involved and when the four workbooks are open, excel is unable to show which workbooks are concerned.
I am an excel user since the very beginning (when excel didn't exist and it was Lotus 1-2-3 and before that it was (1980..).
If nobody can’t solve this problem till no , I will continue my investigation, but a simple procedure should help me very much.
In any case the 4 workbooks are NOT databases (I am familiar with ACCESS and before with Dbase from Borland).
These workbooks are accounting books threatening the finance of a medium company with budgets follow-up and forecast expenses.
NB: the bundle of workbook is the result of a continuous improvement of the program for 23 years and it was functioning very well till a few weeks.
I made a mistake (noy excel) but couldn’t see it immediately so my backups (father and grandfather – every day) had the time to be contaminated and are of no help. This should also be a lesson to me.
Thanks in advance.
- Peten
13 Replies
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
