Forum Discussion
Circular rferencies
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
Great to know you solved an issue, thank you for the feedback.
Do you have named ranges/cells/formulae? If circular reference can't be listed perhaps it's somewhere in names.
Without sample file(s) it's bit hard to say what it could be exactly.
HI,
I do not use named ranges/formulae/cells and I can't send you a sample because these are confidential data. I tried to simulate the fault but couldn't replicate it.
I continue my investigations and if I succeed I will communicate the procedure I have used.
Thanks for your help.