Question 3 Replies 105 Views × Close popover Ashwani Chandnani (AshwaniC) Deloitte Deloitte US View Profile Send Message AshwaniC Member since 2016 5 posts Deloitte Posted: May 1, 2017 Last activity: May 23, 2017 Posted: 1 May 2017 16:31 EDT Last activity: 23 May 2017 16:18 EDT Closed Solved Click on Edit Links on Data Tab in Excel Hi, I want to click on Data Tab and click on Edit Links button and perform some actions on the pop-up screen. How can I do that? I know we cant interrogate Excel in Pega Robotics Studio. I have attached two screen shots to show the places I want to perform action. Thank You Robotic Process Automation × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Accepted Solution Posted: 3 years ago Posted: 1 May 2017 18:26 EDT × Close popover Cecil Howell (howec) PEGA Senior Instructor Pegasystems Inc. US View Profile Send Message howec PEGA replied to AshwaniC The easiest way to do this would be to create a macro in Excel to do what you need and have your automation call the macro. Cecil Howell, CSA | Senior Instructor | Pegasystems Inc. Posted: 3 years ago Posted: 1 May 2017 18:44 EDT × Close popover Christopher Heffernan (heffc) PEGA GCS Solutions Engineer II Pegasystems Inc. US View Profile Send Message heffc PEGA replied to AshwaniC Hello, To interact with Excel we typically use the Excel connector. There is a good tutorial on using more complicated tasks with the Excel connector here https://pdn.pega.com/community/product-support/question/pega-robotics-excel-how . If you'd like more specific direction on using the control connector can you elaborate a bit on your end goal with this automation? What are you trying to achieve? Posted: 3 years ago Posted: 2 May 2017 10:55 EDT × Close popover Ashwani Chandnani (AshwaniC) Deloitte Deloitte US View Profile Send Message AshwaniC Deloitte replied to heffc Thanks for your quick response. My exact steps are: Click on Data Tab on Excel, Then Click on Edit Links button, Choose a file that I was to change, Click Select Source button, Select the new file from the browser, Click OK button on Edit Links screen. I tried Interrogating Data Tab and Edit Links button, but I couldn't do that. I think I will have to use the Macros option.