#1   Report Post  
Posted to microsoft.public.excel.misc
ixlr84fun
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking WorkBOOKS across directories maurices5000 Excel Worksheet Functions 1 December 16th 05 09:41 PM
Dynamic Linking user33 Excel Discussion (Misc queries) 1 August 3rd 05 08:38 PM
Linking worksheets after runnning report Steve Excel Discussion (Misc queries) 0 February 28th 05 09:21 PM
Have to use cursor keys cannot use mouse in excel when linking fo. LUFC Excel Worksheet Functions 0 January 31st 05 09:51 AM
Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 08:27 PM


All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"