I have several links from one workbook to another.
I copy the folder which contains all the workbooks, rename it and replace the workbooks that hold the data. Then when I open the main workbook the data does not update until I actually open the workbooks where the data is coming from.
Is there any way I can get it to update with only the main workbook open? It usually does this for me.
I copy the folder which contains all the workbooks, rename it and replace the workbooks that hold the data. Then when I open the main workbook the data does not update until I actually open the workbooks where the data is coming from.
Is there any way I can get it to update with only the main workbook open? It usually does this for me.
