Easiest way to explain what I’m trying to do is by example – I’m copy/pasting files into a new area, but the new files stay linked to the original files when I want them linked to the new ones. I’ve done it before, just not sure how so trying to figure out the exact criteria for this to work (which would save a lot of work).
Here’s a simplified example of what I’m trying to do. In reality there’s 30-40 files, all linking among each other, so it’s a huge time suck to manually relink everything.
Let’s say I have this folder structure (highlighting that there’s subfolders – seems like that might matter):
\Live\Model 1.xlsx
\Live\Model 2.xlsx
\Live\Assumptions.xlsx
\Live\Support\Industry Model.xlsx
I need to keep all four of those files “live” until we go public with the new numbers, so for the update process I copy/paste the files into a temporary side folder:
\Update\Model 1.xlsx
\Update\Model 2.xlsx
\Update\Assumptions.xlsx
\Update\Support\Industry Model.xlsx
However, when I do that, the links don’t move with it. So all the files in \Update\ will still be linked to the \Live\ folder, and I need to take up to a few hours to relink everything. Then when we go live, it’s a few more hours to relink everything back into the original folder all over again. I know there’s a way to move them over and move the links with them (I’ve unintentionally done it before) – but what’s the criteria?
Thanks
Here’s a simplified example of what I’m trying to do. In reality there’s 30-40 files, all linking among each other, so it’s a huge time suck to manually relink everything.
Let’s say I have this folder structure (highlighting that there’s subfolders – seems like that might matter):
\Live\Model 1.xlsx
\Live\Model 2.xlsx
\Live\Assumptions.xlsx
\Live\Support\Industry Model.xlsx
I need to keep all four of those files “live” until we go public with the new numbers, so for the update process I copy/paste the files into a temporary side folder:
\Update\Model 1.xlsx
\Update\Model 2.xlsx
\Update\Assumptions.xlsx
\Update\Support\Industry Model.xlsx
However, when I do that, the links don’t move with it. So all the files in \Update\ will still be linked to the \Live\ folder, and I need to take up to a few hours to relink everything. Then when we go live, it’s a few more hours to relink everything back into the original folder all over again. I know there’s a way to move them over and move the links with them (I’ve unintentionally done it before) – but what’s the criteria?
Thanks
