I have a large number of Excel files being used in Production (over 100,000). I was wondering whether anyone new of a tool that could review all Excel files to determine whether the files have external links within them.
I have a large number of Excel files being used in Production (over 100,000). I was wondering whether anyone new of a tool that could review all Excel files to determine whether the files have external links within them.
You can loop through the workbooks, opening each in turn, and check the LinkSources property for each. If it returns Empty, there are no links.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks