Workseet linking map

I have some fairly complicated excel files with let say 100 worksheets
in them.

What I would like to do is be able to generate a "map" that would
show me graphically how all the worksheets in the file are linked to
each other.

From the lack of responses to all your posts, I would guess that there is no
such thing.

Maybe you could write a macro that looks through each sheet and searches the
formulas for the exclamation point.

If it's not used in text
="Please do this by: " & text(a1,"mm/dd/yyyy") & "!"

You may get something useful.

ixlr84fun wrote:
>
> I have some fairly complicated excel files with let say 100 worksheets
> in them.
>
> What I would like to do is be able to generate a "map" that would
> show me graphically how all the worksheets in the file are linked to
> each other.

--

Dave Peterson