External Workbook Links Bulk Editor Tool

Excel is really good about resolving external workbook links when the linked files stay together. If you had to move a bunch of complex linked models from server A to server B or from SharePoint site A to site B and external links broke (it happens when Excel stops treating them as relative), you can try bulk editing them using XLLinks Bulk Editor Tool that I just updated for a colleague that upgraded a bunch of xls files to xlsx and moved his workbooks from file shares to SharePoint document libraries. Instructions and scenarios are in the ReadMe file as usual. Open XML files only. Updates include: improved data grid load times and all string comparisons are now case insensitive. One thing you may notice is that there may be more external workbook links embedded in the file than you can see in the Excel UI. Reply to this post if you need to see how to get to them.

This entry was posted in Computers and Internet. Bookmark the permalink.

Leave a Comment or Ask a Question

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s