we have workbooks with links to a number of other workbooks all have the same layout. The master may have ten or more links and the formula in each cell references each of the linked files in a sum.
we have a vba method to ask for new path and then change the link sources with changelink method but for each link changed the sheet updates all formulas. so therefore the formulas are updated in each of 4000 cells for each of the ten or more changes resulting in a very long run time.
Is it possible to change all the link sources before the formulas are updated once only