Macro for list of sheets having links out of workbook.

Hi all,

I have a workbook about to 80 sheets each sheet having links with in workbook. how should i cross check which sheets having links out of workbook.

Thanks in advance.

regards,
suresh

May be try Alt+E+K to know the external reference and use find to search the cells which is using the root path.

Glad it helps you and thanks for the feedback