ThinWorld Citrix Knowledgebase

Wednesday, 17 March 2010

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.



Post a Comment

<< Home