Skip to main content
Question

A11 - How enable content at excel - Security Warning Message

  • May 11, 2023
  • 1 reply
  • 151 views

Forum|alt.badge.img

Hello Friends of AA11

I have a project that I download some SAP reports and make data modeling at Excel Power Query.

My bot is responsible for REFRESH the Excel Spreadsheet, but when my bot open the excel, excel shows to me a SECURITY WARNING because this table is reading data from another place.

I would like to insert a condition in order to identify that everytime that this message appears I’ll click on ENABLE CONTENT and CLICK OK at SECURITY NOTICE.

How is the better way to automatize this process ?

 

1 reply

Forum|alt.badge.img+2

Hi Allan,

You can disable this kind of message on the security settings of Excel or you can make a step in your bot, before actual actions, to open the Excel as a program and deal with its windows to disable it, not using the Excel actions.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings