Find Excel Links Macro
This Excel Macro searches a specified path (eg: S:\Shared Documents)
for any Excel spreadsheets that contain links within them to other excel spreadsheets.
This is very handy for identifying spreadsheets that may be impacted by a move of the data share. Hardcoded path locations in spreadsheets may obviously stop working if data is moved to a new location.
Simply open the attatched spreadsheet in Microsoft Excel and follow the oncscreen form.
ScanLinks.xls
for any Excel spreadsheets that contain links within them to other excel spreadsheets.
This is very handy for identifying spreadsheets that may be impacted by a move of the data share. Hardcoded path locations in spreadsheets may obviously stop working if data is moved to a new location.
Simply open the attatched spreadsheet in Microsoft Excel and follow the oncscreen form.
ScanLinks.xls
posted by Tomo at
Wednesday, March 17, 2010
0 Comments:
Post a Comment
<< Home