Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)

Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)

 

 

With this Excel trick you can use a formula to show all the external links in your Excel workbook in one place. This way you can keep an eye on where the data is coming from and if any link is pointing to the wrong workbook.  

 

With this Excel hack you can also write a formula to get the list of files from a specific directory and bring it to your Excel sheet. So if you're waiting for your colleague to add a file to a directory, you'll be able to see it in your Excel formula results once you refresh the list. The fun part about this Excel trick is it combines 4.0 Excel Macros with Excel dynamic arrays. You can use the Excel Transpose function to get a vertical list of external links for file names. 

Related Topics:

• How to Remove or Replace Errors in Your Pivot Tables
• MTD Pivot Table Calculation for Christopher 
• Pivot Table Calculation Type Default to Sum Instead of Count
• Slicer Pivot Table Cache Relationship and the Filter Controls Error