Excel Popup Issue

[babaiah]

Hello All,

We are getting the following popup when opening Excel. Does anyone have suggestions on how to handle this?

Thank you.

[harish.mogulluri]

Hi @babaiah 

Based on the exception  you have provided, it looks like the excel file you opened has references present in the file and it might be  updated or deleted.  if that is the case you need to correct the references to resolve the issue.

Refernece should be either reference from other excel sheet or data source.

[michaeloneil]

Hi @babaiah 

As @harish.mogulluri mentioned it looks like the file you are opening has links to other files and the files they are linking to are missing. You can try turning off auto updates for the links after creating and instance and before you open the file. This should prevent the file trying to update the links when it opens and resolve the issue with the pop up. You would need a new code stage for that though, i've place the code below if you need it. Inputs are Handle, Workbook and Auto Updates the last one should be a flag data item.

Dim wb As Object

Try 

wb = GetWorkbook(Handle, Workbook)

wb.Activate()

wb.UpdateRemoteReferences = Auto_Updates

Success = True

Catch e As Exception

Success = False

Message = e.Message

Finally

wb = Nothing

End Try

[stepher]

Just a note.  I noticed that in later versions of the MS Excel VBO, the "Open Workbook" action now has a flag for updating links.  I don't know if this is actually helpful or not.

Good luck,

Red

[babaiah]

Thank you for your reply, Stepher.

Could you please share the link to the latest version of MS Excel VBO?

[stepher]

No worries.  Here you go...

https://digitalexchange.blueprism.com/cardDetails?id=115181

Take care,

Red

[babaiah]

Thank you all for your replies.

We have created a macro to handle the Excel pop-ups, and now we are not facing any issues.