topic Re: Fill cell color in Excel not working after upgrade to Server 2022 and 64 bit Office in Product Forum

Fill cell color in Excel not working after upgrade to Server 2022 and 64 bit Office

Jesada — Fri, 31 Jan 2025 22:34:49 GMT

Hello,

Currently running:

Blue Prism Enterprise v7.3 - 64 bit

Windows Server 2016

Office 2013 - 32 bit

We are currently building out a new environment to move from Server 2016 to Server 2022. We are also upgrading to Office 2024 - 64 bit. We will remain on Blue Prism v7.3. In the 2022 environment, a previously working Excel action is now throwing an error regarding the Microsoft.Office.Interop.Excel.dll file when we try to run the action. There are no errors/warnings on the object.

I have updated the code options on the Initialise page of the object to point to the new location of the dll.

Existing 2016

New 2022

The action we are trying to run is on the page "Fill Cell Range Background Color - All Colors" - in this case Code17, but the error occurs for all of them.

Error message:

Internal : Could not execute code stage because exception thrown by code stage: Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

Any advice would be appreciated! Thank you in advance.

Re: Fill cell color in Excel not working after upgrade to Server 2022 and 64 bit Office

SayeedBinAbdullah — Sun, 02 Feb 2025 06:12:18 GMT

Hello @Jesada

It seems the DLL file in the Blue Prism folder is missing. Could you please verify if the DLL file shown in the picture is available in the new 2022?

Best Regards,

Sayeed Bin Abdullah

Re: Fill cell color in Excel not working after upgrade to Server 2022 and 64 bit Office

Jesada — Tue, 04 Feb 2025 19:17:08 GMT

Thank you Sayeed, that fixed it for us!

Re: Fill cell color in Excel not working after upgrade to Server 2022 and 64 bit Office

SayeedBinAbdullah — Wed, 05 Feb 2025 04:54:15 GMT

I'm glad to hear that the issue has been resolved. If you found my solution helpful, please consider voting for it as the "Best Answer". Thank you!

Regards,
Sayeed Bin Abdullah