Changed file opening behavior from OOTB Workflow Tasks

%3CLINGO-SUB%20id%3D%22lingo-sub-162825%22%20slang%3D%22en-US%22%3EChanged%20file%20opening%20behavior%20from%20OOTB%20Workflow%20Tasks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-162825%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20OOTB%20Approval%20Workflow%26nbsp%3Bsends%20an%20email%20to%20the%20approver%20with%20a%20direct%20link%20to%20the%20Related%20Content%20%2F%20Document.%20When%20the%20Approver%20clicks%20on%20this%20I%20would%20expect%20it%20to%20open%20in%20the%20Online%20browser.%20In%20this%20case%20the%20following%20behavior%20happens%2C%20I%20have%20used%20an%20Excel%20file%20as%20an%20example%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EChrome%20automatically%20downloads%20the%20file%20and%20forces%20the%20user%20to%20save%20it%20somewhere%20which%20then%20%22unlinks%22%20the%20document%20from%20the%20SharePoint%20library.%20The%20user%20has%20to%20make%20the%20changes%20and%20upload%20the%20file%20over%20the%20old%20file%20to%20get%20it%20updated%20in%20SharePoint.%3C%2FLI%3E%0A%3CLI%3EIE%20will%20download%20the%20file%20but%20with%20the%20yellow%20warning%20and%20%22Edit%20Workbook%22%20button.%20Once%20this%20is%20clicked%20the%20document%20is%20in%20edit%20mode%20and%20still%20linked%20to%20the%20SharePoint%20library.%3C%2FLI%3E%0A%3CLI%3EIf%20you%20go%20to%20the%20document%20through%20IE%20rather%20than%20using%20the%20link%20from%20the%20external%20system%20and%20click%20on%20the%20document%20then%20Excel%20Online%20opens.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EIs%20there%20a%20way%20to%20get%26nbsp%3Bthe%20document%26nbsp%3Bto%20either%20open%20in%20Excel%20Online%20or%20at%20a%20minimum%20keep%20the%20link%20to%20the%20document%20to%20prevent%20the%20user%20from%20having%20to%20save%20it%20and%20upload%20it%20which%20messes%20up%20the%20approval%20workflow%3F%20The%20library%20setting%20for%20default%20behavior%20is%20to%20use%20the%20server%20default%20(open%20in%20browser).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20same%20behavior%20happens%20in%20Tasks%20when%20opening%20the%20document%20from%20the%20Related%20Content%20link%2C%20and%20also%20when%20in%20the%20task%20itself.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20borrowed%20the%26nbsp%3Btext%26nbsp%3Bfrom%20this%20previous%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSharePoint%2FChrome-open-in-Excel-downloads-the-file%2Fm-p%2F126653%2Fhighlight%2Ftrue%23M11341%22%20target%3D%22_blank%22%3Epost%3C%2FA%3Eas%20it%20seems%20to%20be%20an%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-162825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-162969%22%20slang%3D%22en-US%22%3ERe%3A%20Changed%20file%20opening%20behavior%20from%20OOTB%20Workflow%20Tasks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-162969%22%20slang%3D%22en-US%22%3EYup%2C%20use%20this.%20It's%20the%20same%20for%20Office%20online.%20Should%20get%20you%20what%20you%20need.%20%3CA%20href%3D%22http%3A%2F%2Fpaulryan.com.au%2F2013%2Flink-to-open-in-browser-with-owa%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fpaulryan.com.au%2F2013%2Flink-to-open-in-browser-with-owa%2F%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

The OOTB Approval Workflow sends an email to the approver with a direct link to the Related Content / Document. When the Approver clicks on this I would expect it to open in the Online browser. In this case the following behavior happens, I have used an Excel file as an example:

  1. Chrome automatically downloads the file and forces the user to save it somewhere which then "unlinks" the document from the SharePoint library. The user has to make the changes and upload the file over the old file to get it updated in SharePoint.
  2. IE will download the file but with the yellow warning and "Edit Workbook" button. Once this is clicked the document is in edit mode and still linked to the SharePoint library.
  3. If you go to the document through IE rather than using the link from the external system and click on the document then Excel Online opens.

Is there a way to get the document to either open in Excel Online or at a minimum keep the link to the document to prevent the user from having to save it and upload it which messes up the approval workflow? The library setting for default behavior is to use the server default (open in browser).

 

The same behavior happens in Tasks when opening the document from the Related Content link, and also when in the task itself.

 

I have borrowed the text from this previous post as it seems to be an issue.

1 Reply
Highlighted
Yup, use this. It's the same for Office online. Should get you what you need. http://paulryan.com.au/2013/link-to-open-in-browser-with-owa/