Can cells containing linked formulas be identified?
 

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???

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

Vaya con Dios,
Chuck, CABGx3


"EA" wrote in message
...
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???

This might work for you....

EditFind
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

Hi EA,

See also response(s) in Misc.


---
Regards,
Norman



"EA" wrote in message
...
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???