Find Linked Cells
Anyone know of a way to scan all Excel files in a drive to
find out if they have external links?
The issue is that our drive mappings are about to change
so a cell that contains a link to T:\workbook.xls should
now be pointing to G:\workbook.xls. I would like to be
able to scan all network drives for any Excel files that
contain linked cells so that I do not have to open each
one individually and go through Edit-Links to find them.
Is this possible or am I dreaming?
Thanks!
|