topic Microsoft office documents with external references in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/microsoft-office-documents-with-external-references/m-p/304070#M257200 <HTML><HEAD></HEAD><BODY><SPAN>Hello all,</SPAN><BR /><BR /><SPAN>I am wondering if it is possible to get the following situation to work in Alfresco:</SPAN><BR /><BR /><SPAN>On an external hard-drive there are three documents. Word document A, Excel sheet B and Excel sheet C.</SPAN><BR /><SPAN>-Word document A refers to Excel sheet B to get information for tables in the document.</SPAN><BR /><SPAN>-Excel sheet B refers to Excel sheet C to get input for it's tables.</SPAN><BR /><BR /><SPAN>The customer has two use cases:</SPAN><BR /><SPAN>-Open the Word document A. Microsoft Word automatically gets information from the referred Excel sheet B.</SPAN><BR /><SPAN>-Open the Excel document B. Microsoft Excel automatically gets information from the referred Excel sheet C.</SPAN><BR /><SPAN>-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.</SPAN><BR /><BR /><SPAN>This works on the external hard-drive. But is it possible to use external links to other Microsoft Office documents like this in Alfresco? </SPAN><BR /><BR /><SPAN>Webdav and CIFS seem like an option, but I am not quite experienced enough with either to say for sure.</SPAN><BR /><BR /><SPAN>Any help would be greatly appreciated!</SPAN></BODY></HTML> Wed, 31 Jul 2013 09:53:54 GMT jod 2013-07-31T09:53:54Z Microsoft office documents with external references https://connect.hyland.com/t5/alfresco-archive/microsoft-office-documents-with-external-references/m-p/304070#M257200 Hello all,I am wondering if it is possible to get the following situation to work in Alfresco<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />n 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 re Wed, 31 Jul 2013 09:53:54 GMT https://connect.hyland.com/t5/alfresco-archive/microsoft-office-documents-with-external-references/m-p/304070#M257200 jod 2013-07-31T09:53:54Z Re: Microsoft office documents with external references https://connect.hyland.com/t5/alfresco-archive/microsoft-office-documents-with-external-references/m-p/304071#M257201 <HTML><HEAD></HEAD><BODY><SPAN>I think Using CIFS is possible in theory,but it may not work in practice,because there are many constraints on it.</SPAN><BR /><SPAN>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. </SPAN><BR /><SPAN>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. </SPAN><BR /><SPAN>Generally C drive dose exist,So you should map "office" node to another drive ,in this situation,A still can't refer B.</SPAN></BODY></HTML> Thu, 01 Aug 2013 02:37:44 GMT https://connect.hyland.com/t5/alfresco-archive/microsoft-office-documents-with-external-references/m-p/304071#M257201 kaynezhang 2013-08-01T02:37:44Z