how to find which cells link to a diff tab / diff workbook?

[bigdan]

Sometimes when I'm on a worksheet I'd like to know which cells here pull in data from an outside source, whether it's a diff tab within the workbook, or a diff workbook altogether. Is there a way to do this?

Finding all cells which are formulas is simple enough. I just do a search for the equal sign. But this is a bit more complicated.

 

[wist]

you can display the formulas by pressing Ctrl+` (located left from number 1 key) so you would also see if they are linked to a file... you can also search for "!" or "[" characters which are used when cell is linked to a file or a sheet

 

[Jeffrey Mahoney]

Use conditional formatting. A formula based conditional format to look for "HTTP" or "/".

 

[bigdan]

i'm confused, what would http or / do?