Excel “Pull” Function: Creating dynamic links to closed workbooks ... He wrote an Excel function in VB called PULL which essentially fixes INDIRECT's fatal flaw and allows the user to create links to closed workbooks. Just copy the ...