What is the recommended save procedure when working with Linked workbooks?
To ensure I have sufficient backup of my model (and for reconciliation purposes) I always save down my model with a new version number but from what I can tell if I introduce linked workbooks all linked workbooks to be open at the same time which will significantly increase save time.
Just curious what you guys are doing with regards to saving back-ups in general but more specifically when using linked workbooks?
T
Hi Tarjei,
The key with multi-linked workbook projects is removing the versioning from the workbook file names and moving it up into the parent directory name, as shown below.
Then, after making changes to the models which warrant a version increment, close all linked workbooks in the project, copy and paste the entire folder, then version increment the folder name.
You can then periodically delete older versions if you're worried about the amount of storage you're using, but we rarely have that issue given model computer and cloud-based storage capacities.
M.