Excel “Pull” Function: Creating dynamic links to closed workbooks | Numbermonger

Hi harlan grove, This function is slow for only one reason. The Set xlapp = CreateObject(“Excel.Application”) has been defined in the function, which creates a new object every time a cell is changed. We need to initialize it only once. So you can just de

numbermonger.com