Can I trace dependants for a multiple selection?
 

Hi,

Is it possible to trace dependants for selected cells, rather than just the
active cell? Preferably I would like to trace an entire worksheet. My
objective is to determine whether a worksheet is linked to any other
worksheets.

Bryce

Can I trace dependants for a multiple selection?
 

If you're looking for links to worksheets within the same workbook, you could
use edit|find and search for the exclamation point (!).

You may get a few false positives if you have text in your worksheet:

=if(a15,"Too many!","Very Good!")


If you're looking for links to worksheets in other workbooks, you may want to
use this.

Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

======
I've done this to find links between worksheets in the same workbook.

Copy the workbook (don't destroy the original!).
Move the worksheet to a new workbook (not copy)
Then use Bill Manville's findlink program to search for links to the original
copy.

BMA wrote:

Hi,

Is it possible to trace dependants for selected cells, rather than just the
active cell? Preferably I would like to trace an entire worksheet. My
objective is to determine whether a worksheet is linked to any other
worksheets.

Bryce

--

Dave Peterson

Can I trace dependants for a multiple selection?
 

Thanks mate,

This should work fine as I dont have any exclamation marks as text entries.
Seems as simple solution,

Cheers

"Dave Peterson" wrote:

If you're looking for links to worksheets within the same workbook, you could
use edit|find and search for the exclamation point (!).

You may get a few false positives if you have text in your worksheet:

=if(a15,"Too many!","Very Good!")


If you're looking for links to worksheets in other workbooks, you may want to
use this.

Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

======
I've done this to find links between worksheets in the same workbook.

Copy the workbook (don't destroy the original!).
Move the worksheet to a new workbook (not copy)
Then use Bill Manville's findlink program to search for links to the original
copy.

BMA wrote:

Hi,

Is it possible to trace dependants for selected cells, rather than just the
active cell? Preferably I would like to trace an entire worksheet. My
objective is to determine whether a worksheet is linked to any other
worksheets.

Bryce

--

Dave Peterson