cancel
Showing results for 
Search instead for 
Did you mean: 

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

jbunnorat
Level 2

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

jbunnorat_0-1738361593484.png

New 2022

jbunnorat_1-1738361626012.png

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. 

jbunnorat_2-1738361780803.png

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. 

 

 

 

0 REPLIES 0