Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workseet linking map
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking WorkBOOKS across directories | Excel Worksheet Functions | |||
Dynamic Linking | Excel Discussion (Misc queries) | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Have to use cursor keys cannot use mouse in excel when linking fo. | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions |