Microsoft office documents with external references

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

jod

Hello all,

I am wondering if it is possible to get the following situation to work in Alfresco:

On an external hard-drive there are three documents. Word document A, Excel sheet B and Excel sheet C.
-Word document A refers to Excel sheet B to get information for tables in the document.
-Excel sheet B refers to Excel sheet C to get input for it's tables.

The customer has two use cases:
-Open the Word document A. Microsoft Word automatically gets information from the referred Excel sheet B.
-Open the Excel document B. Microsoft Excel automatically gets information from the referred Excel sheet C.
-Open Word document A, open Excel documents B and C. While working on Word document A, also update Excel document B and C so the new data is put into Word document A.

This works on the external hard-drive. But is it possible to use external links to other Microsoft Office documents like this in Alfresco?

Webdav and CIFS seem like an option, but I am not quite experienced enough with either to say for sure.

Any help would be greatly appreciated!

kaynezhang

I think Using CIFS is possible in theory,but it may not work in practice,because there are many constraints on it.
MS office document reference is implemented by Object Linking and Embedding.If word document A refers to Excel sheet B ,then A (for example saved in C:\office\A.docx) knew B's(for example saved in C:\office\B.xls) storage address.
After you save A and B into alfresco repository,A still refer B at C:\office\B.xls,to make sure A can load B ,the node in which B saved must be named "office" and the node named "office" must be mapped as C drive.
Generally C drive dose exist,So you should map "office" node to another drive ,in this situation,A still can't refer B.