Precedent sheets

[PATSYS]

I have a sheet that takes values from several other sheets in the same workbook.

Is there an easy way for me to know whch specific sheets are being linked to my sheet.

The reason for this requirement is that I am deleting several sheets in the workbook except those that has something to do with one of the sheets.

Thanks

 

[tusharm]

One way to do this by hand is to use the Show Precedents button on the Formula Auditing toolbar. Hopefully, how to use the result will be self-evident since explaining it in text-only mode is particularly challenging.

 

[PATSYS]

One way to do this by hand is to use the Show Precedents button on the Formula Auditing toolbar. Hopefully, how to use the result will be self-evident since explaining it in text-only mode is particularly challenging.

Hi Tushar,

Not sure I understand. The trace precedent in TOOLS-FORMULA AUDITING is per cell. I was thinking perhaps there is a way that I can view all the precendent sheets that affects a certain sheet. Going cell by cell using the precedent button will mean I go through several thousands cells.

Well anyway just in case you can think of something, I'd very much appreciate to hear.

Thanks

 

[tusharm]

Ah, well. You have a major task on your hands. Using code to build a precedent list when the precedents are on another sheet/book is non-trivial (and I suspect no solution will be truly robust).

I don't know if anyone has written a solution that is available on the 'Net. I've been working off-and-on on one for a while now. From my testing it appears to work but I still have to add the UI needed for others to use it.

Edit: There must be a logical basis on which you create links to other sheets/books. Instead of trying to find the links working from the cells, why not work "top down," as it were? If you know the basis for the links, you should be able to figure out what sheets/books the links point to.

Also, if your links are to other workbooks (and not just sheets in the same book), check out Bill Manville's FindLink utility. It's hosted by Stephen Bullen at www.oaltd.co.uk It may (or may not) provide you with what you want.

 

[PATSYS]

The thing is that I did not build this workbook/worksheet that I am working on. But thanks for the advice anyway.