topic Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel in Digital Exchange

NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel VBO

ewilson — Tue, 15 Oct 2024 17:34:00 GMT

Today we released version 10.4.0 of the MS Excel VBO on to the Digital Exchange. This version introduces support for Microsoft's Sensitivity Label feature in Workbooks. There are two actions you can leverage if your organization makes use of Sensitivity Labels:

Get Workbook Sensitivity Label Info - This action will return any existing Sensitivity Label information that's been applied to a specified Workbook
Set Workbook Sensitivity Label Info - This action is used to set a new Sensitivity Label on a Workbook or change an existing label value. NOTE: This action should be called before you attempt to save a newly created Workbook. Also, if you try to downgrade and existing label, your organization will likely require that you include a justification with your request. There, we've exposed an optional Justification input data item on this action.

You can find the latest VBO here:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Cheers,
Eric

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

acatalano — Wed, 22 Jan 2025 13:14:47 GMT

Hi Eric,

I was testing these new actions, and I found the following:
-For Excel files created with Blue Prism, the label works.
-But for existing Excel files where you want to modify the label, it doesn't. The error is Could not execute code stage because exception thrown by code stage: Excepción de HRESULT: 0x80040400

It doesn't matter if it's updating or downgrading the label, both cases fail.

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

ewilson — Wed, 22 Jan 2025 14:31:33 GMT

@acatalano so you're able to open the Excel file and perform work on it, it's just these actions that don't succeed? What versions of BP and Excel are you using?

Cheers,
Eric

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

acatalano — Wed, 22 Jan 2025 15:15:35 GMT

@ewilson Correct, only Set label action doesn´´`t work for existing files.

Blue prism version is 7.3.1 and excel 365 MSO (version 2412)

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

ewilson — Fri, 24 Jan 2025 15:40:59 GMT

@acatalano ok, so you can get the label info but not set or override it. Looks like we're on Excel 365 version 2408. We'll run some more tests to see if we can recreate your issue. Stay tuned.

Cheers,
Eric

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

Neel1 — Tue, 28 Jan 2025 17:17:35 GMT

Hello @ewilson - i also tried it. and set sensitivity label did not work for manually created file.

Excel version is 2411

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

ewilson — Thu, 30 Jan 2025 16:00:01 GMT

@Neel1 @acatalano

We're looking into it further.

Cheers,
Eric

Re: NOTICE: Support for Microsoft Information Protection Labels (aka Sensitivity Labels) in MS Excel

Neel1 — Mon, 28 Apr 2025 15:28:28 GMT

Hey @ewilson @GeoffHirst - is this issue resolved?