Link within Excel Files and Vault Collaboration 2013

[BL-GL]

Hello,

I am using Excel files (xls or xlsx) with links between some cells from one file (named for exemple A.xls) to cells to the other file (named for exemple B.xls).

In A.xls file, the cell containing the link is like "=C:\Vault\B.xls|Sheet Name|CellCoordinate".

I would like to say that I will agree to use another solution for the link between the two files accordingly your answers to my following questions.

My computer is installed with Vault Collaboration Explorer Client 2013 and also the Vault Collaboration Office Client 2013.

I am using Office 2007.

My questions are :

1) Is there a way to check-in my linked Excel files within Vault with the preservation of the link?

2) Is it possible to view in the explorer that the linking file (ie A.xls) as a link with the linked file (ie B.xls) ?

3) Is there a way to automatically check-out the linked files when I check out the linking files or to receive message from Vault meaning that I have also to check out the B.xls file ?

Thank you very much for your help.

Bernard.

[Gabriel_Watson]

What you are looking for is the "Attach" function in Vault (little paper clip):

When you CheckOut/Get/Open a file from Vault you should leave the "Include Attachments" option on, so that all referenced files will be acquired:

 

Attachments should also show up on the "Where Used" list and their master files will show the hierarchy under "Used", accordingly:

                           

As long as both master and attached file are downloaded to their relative folders (where the links can target the other document relative to where the files are saved), the sheets should be able to find each other and work together.