Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular reference
I have a circular reference in my file, however it doesn't show when I try to
view using the circular reference toolbar. This is a very large file that was someone else's, and I am concerned there may be more that I am missing. What is the easiest way to view all circular references in a file? Thanks, Adella |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular reference
Maybe Stephen Bullen's utility will help find that circular reference.
http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Adella wrote: I have a circular reference in my file, however it doesn't show when I try to view using the circular reference toolbar. This is a very large file that was someone else's, and I am concerned there may be more that I am missing. What is the easiest way to view all circular references in a file? Thanks, Adella -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular reference
Adella,
Try my XspandXL addin on my site. There's a selection of auditing tools that look at circulars and will list all the circulars in your book in one go. Robin Hammond www.enhanceddatasystems.com "Dave Peterson" wrote in message ... Maybe Stephen Bullen's utility will help find that circular reference. http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Adella wrote: I have a circular reference in my file, however it doesn't show when I try to view using the circular reference toolbar. This is a very large file that was someone else's, and I am concerned there may be more that I am missing. What is the easiest way to view all circular references in a file? Thanks, Adella -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference help | Excel Discussion (Misc queries) | |||
circular reference | Excel Discussion (Misc queries) | |||
Is this possible? (Circular reference?) | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Worksheet Functions | |||
Circular reference | Excel Worksheet Functions |