Last month I had a workbook called "06 2011 Labor" linked to a workbook called "06 2011 ODC."
Now this month, I open "06 2011 Labor" and do File, Save As "07 2011 Labor" and also open "06 2011 ODC" and do File, Save As "07 2011 ODC."
So now I am working with "07 2011 Labor" and "07 2011 ODC" in the current month. The files called "ODC" contain the "source data" which will feed into the "Labor" files (the links are established in the "Labor" files).
In "07 2011 Labor," of course I still have links pointing to "06 2011 ODC," but I want to update them somehow or have them automatically update so that the links will now point to "07 2011 ODC" for the current month.
They would still be linked to the exact same cell references, it's just that the file name of the "source data" changed from "06 2011 ODC" to "07 2011 ODC."
Is there a way to do this?
Now this month, I open "06 2011 Labor" and do File, Save As "07 2011 Labor" and also open "06 2011 ODC" and do File, Save As "07 2011 ODC."
So now I am working with "07 2011 Labor" and "07 2011 ODC" in the current month. The files called "ODC" contain the "source data" which will feed into the "Labor" files (the links are established in the "Labor" files).
In "07 2011 Labor," of course I still have links pointing to "06 2011 ODC," but I want to update them somehow or have them automatically update so that the links will now point to "07 2011 ODC" for the current month.
They would still be linked to the exact same cell references, it's just that the file name of the "source data" changed from "06 2011 ODC" to "07 2011 ODC."
Is there a way to do this?
