none
Strange behaviour - Word 2010 and linked OLE objects in SharePoint document library RRS feed

  • Question

  • Hi,

    I am encountering very strange behaviour in Word 2010:

    1. I have word document with linked Excel sheets/charts/fields (linked to xlsm files), which is downloaded from one SharePoint server.
    2. For testing purposes, I'm uploading those files to another doc lib in SharePoint Foundation 2010. Before that, I'm editing links to files manually, in Visual Studio OpenXML editor (Power Tool).
      Before: <Relationship Id="rId16" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/oleObject" Target=http://oldSharePointUrl/SomeLibrary/filename.xlsm!Sheet!Range TargetMode="External"/>
      After: <Relationship Id="rId16" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/oleObject" Target=http://NewSharePointUrl/NewDocLib/filename.xlsm!Sheet!Range TargetMode="External"/>
    3. After I upload files, and  open them in Word, links to sheets and charts are broken, such as that in document.xml part attribute ProgId value is rewriten, and instead of ProgId="Excel.Sheet.8" becomes ProgId="http://NewSharePointUrl/NewDocLib/filename.xlsm!Sheet!Range"

    And, you can guess, links become invalid and objects cannot be updated.

    Anyone had this? Is this a bug in Word?

    I don't think that I'm invalidating word files by editing XML parts in VS, because I am only changing URLs.


    Dragan Panjkov [http://www.dragan-panjkov.com]
    Wednesday, January 11, 2012 6:00 PM

All replies

  • Hi Dragan,

    Thank you for posting.

    I will involve others to help you about this problem. There might be some delay about the response. Appreciate your patience.

    Best Regards,


    Bruce Song [MSFT]
    MSDN Community Support | Feedback to us
    Thursday, January 12, 2012 5:21 AM
  • Dragan, Would you validate the modified document with Open XML SDK Power Tool?  This tools suppose to tell errors or corrupt in Excel or Word documents. It can be downloaded at: http://www.microsoft.com/download/en/details.aspx?id=5124

    Wait for you reply.

    Best Regards,


    Forrest Guo | MSDN Community Support | Feedback to us

    Thursday, January 12, 2012 7:08 AM
    Moderator
  • I already tried that (but haven't mentioned in previous post). Result is Green - No validation errors.
    Dragan Panjkov [http://www.dragan-panjkov.com]
    Thursday, January 12, 2012 8:50 AM
  • OK. Then I try to get other people help on this question. Please wait some time.

    Best Regards,


    Forrest Guo | MSDN Community Support | Feedback to us

    Thursday, January 12, 2012 9:25 AM
    Moderator
  • Hi Dragan,

    You have done the appropriate steps to identify the reason for the problem or eliminate it. Because of the complexity of establishing the environment to troubleshoot and the need for a repro your issue falls into the paid support category which requires a more in-depth level of support.  Please visit the below link to see the various paid support options that are available to better meet your needs. http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    Regards,
    Chris Jensen
    Senior Technical Support Lead


    Friday, January 13, 2012 8:22 PM
    Moderator
  • Thank you, Chris.

    However, I am perceiving MSDN forums as community feedback channel, and not as sales channel for Microsoft support. Honestly, I expected a reply from some of MCCs or MVPs.

    On the other hand, the issue can be easily reproduced using Microsoft IW Demo VM (Contoso, 2010-10A) that can be freely downloaded from Microsoft Download center. That VM contains SharePoint, Word and Excel, which are all someone needs in order to confirm the issue.

    Kind regards


    Dragan Panjkov [http://www.dragan-panjkov.com]
    Wednesday, January 18, 2012 1:10 PM
  • Hello Dragan,

    Thank you for your remarks.

    You’re correct about the purpose of the Forum. The Forum Moderator gets involved when she or he can understand the issue and determines that none of the MCCs or MVPs, or any of the many other Forum browsers has responded with an answer. The Moderator may refer the issue to a ‘Subject Matter Expert’ The SME may provide a resolution, or determine that the issue involves multiple subjects and experts in order to establish that there could be a bug in a product, or to spend the resources needed to work through the code in order to resolve the issue.

    Your original question was “Is this a bug in Word?”

    It may be a bug in Word.  It may be the Reference in the document.xml run is affected. Or the reference in the .rels file is affected. It may be an issue with how you’re using XML, or with XML itself. It may be a SharePoint behavior. The issue may be “By design”

    In order to report it as a bug  in a Microsoft product you need to interact with a a Microsoft customer Support Engineer The conduit to Microsoft Product Development is through Microsoft Customer Support. The door to a Customer Support engineer is through paid support. When the support engineer has determined which product has the bug –if it is a bug – the support incident will be made “no charge.”

    The choice to connect with Microsoft Customer Support is yours.

    Regards,
    Chris Jensen
    Senior Technical Support Lead


    Chris Jensen
    Wednesday, January 18, 2012 3:26 PM
    Moderator
  • Thank you for clarifying your previous post, Chris.

    This issue (although really strange considering the fact that docx is packaged xml structure) is not a showstopper in my project - so I will not connect to Microsoft Support.

    It would be nice if you can forward it through internal channels, at least to try to repro this issue and confirm what is causing it. I am more than happy to help with that during my free time.

    Kind regards

    Dragan

     


    Dragan Panjkov [http://www.dragan-panjkov.com]
    Wednesday, January 18, 2012 6:16 PM
  • Hi,

    This behavior is definitively a bug in Word... I just got the same problem this week.  As soon as you add a linked object to a file in sharepoint (with either the UNC or HTTP address), the link is broken as soon as you close the document and you reopen it.

    I'll see to open the bug report.

    Chris

    Wednesday, January 25, 2012 1:51 PM
  • I'm seeing the same behaviour. I'd love to know of a work-around or fix
    Tuesday, June 19, 2012 1:39 AM
  • Hello Dragan,

    For a fairly complete explanation of this well known problem, please read my posts near the end of this topic:

    http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010setup/thread/8551c173-3ba2-4163-9050-6d5ce38356de

    The title isn't particularly relevant, but the bottom line is that it's a bug in SharePoint 2007/2010 and was supposed to be fixed in the Feburary? 2012 cumulative update.  Unfortunately MS dropped the ball and only fixed it in SP 2010, so as far as I know it still exists in SP2007. 

    It's not a bug in MS Office (Word/Excel/Powerpoint, etc) but rather in SharePoint's Office Document parsers which transfer properties of the SharePoint list columns to the office document so that QuickParts can be used.

    You can work around this by disabling the Document Parsers through powershell.  Or by not storing office documents in sharepoint!

    I worked for nearly a year with MS on this. I'll probably never attempt to get another bug fixed in a microsoft product again after this incredible and frustrating experience.

    Thursday, October 25, 2012 3:36 PM