WorkSheets

[Evagrius Ponticus]

Hi,

I just received a workbook with many worksheets. I am only interested in one of those worksheets - I would like to delete the rest.

Is there a simply way for me to determine if the one worksheet I need references other worksheet w/out having to check every cell?

Thank You!

 

[JackDanIce]

Use the formula auditing tools

 

[Evagrius Ponticus]

Hmmm - don't I have to do that for each cell though?

 

[Evagrius Ponticus]

^

 

[Dave Patton]

search for ! Ctrl +f and then !

It will highlight formulas to other sheets such as 1a in my spreadsheet ='1a'!C2*1.


If you use " ! " in your cells,


You could use VBA to print the formulas for the sheet and then search as above.