Links between Excel documents

[Former Member]

Dear all

I manage different Excel documents. All Excel documents / ~cells have links among each other like =(Test1.xls)Table1!$E$18.

Is there a way /workaround to maintain the links if I manage these files with SAP-DMS?

Thanks in Advance,

Points will be rewarded for useful information.

AJK

[Former Member · Accepted solution]

i don't think it is possible in SAP DMS

But you can do one thing. Attach all file in single DIR (You must have installed Content server for this)

and while retrieval extract all the document to local system and then use.

or try using easy DMS which is integrated with windows explore.but

i am not sure it will work

[Former Member]

Thanks,

easyDMS: It works fine (all documents in a single DIS)!

Sap-GUI: It doesn´t work. A possible reason could be everytime I modify the documents the documentname (e.g. test.xls) will be changed (in temptest.xls) although I selected in IMG u201Cno renaming of temporary fileu201D. No OSS hint.

Any idea appreciated.

Thanks a lot,

AJK

[Former Member]

This is not possible because DMS stores originals and not supports any relation between two orginals.

What you can do is that you store all originals in one DIR so when user will open it he will have relations maintained within originals