Can cells containing linked formulas be identified?

E

EA

I have an Excel file that has formulas to another Excel file. Is there a way
I can view a list containing all cells that have linked formulas instead of
having to look for them cell-by-cell???
 
C

CLR

Not exactly what you asked for, but F5 > Special > Formulas > OK will
highlight all the formulas in the sheet...........

Vaya con Dios,
Chuck, CABGx3
 
R

Ron Coderre

This might work for you....

Edit>Find
Find What: Enter the left square bracket [
(That character is in formulas linked to other workbooks)
Then click [Find All]

The Find window will then expand to list all instances of the cells that
contain that character.
Clicking on any of them will display the referenced cell


Does that help?
Ron
 
Top