topic Re: Excel Popup Issue in Digital Exchange

Excel Popup Issue

babaiah — Tue, 28 Jan 2025 16:09:58 GMT

Hello All,

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

Thank you.

Re: Excel Popup Issue

harish.mogulluri — Wed, 29 Jan 2025 04:01:13 GMT

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.

Re: Excel Popup Issue

michaeloneil — Wed, 29 Jan 2025 12:12:31 GMT

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

Re: Excel Popup Issue

stepher — Thu, 30 Jan 2025 15:59:30 GMT

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

Re: Excel Popup Issue

babaiah — Thu, 30 Jan 2025 16:16:08 GMT

Thank you for your reply, Stepher.

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

Re: Excel Popup Issue

stepher — Thu, 30 Jan 2025 16:29:20 GMT

No worries. Here you go...

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

Take care,

Red

Re: Excel Popup Issue

babaiah — Fri, 31 Jan 2025 11:24:34 GMT

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.