I am trying to write range into excel but that excel is having inbuilt links… So popup of Update, Don’t update appears… How to handle such files??
Try using check app state
Use Write Range Workbook activity. This will write the datatable without opening the file.
- You can go to advanced settings in excel and there turn off auto update feature or ask for update
- Alternately try with workbook activities
Cheers
When excel is having reference of the other excel files this kind of pop up appear. now if this will have any dependency in your work while u r working on excel
Use parallel activity in which add first sequence with your logic and second with to handle this pop by click activity or send hot key as ‘esc’
If this is not required u can use suggestion mentioned above like excel pop setting and using workbook activities ! @Omkar_Shete_CTR
The Excel Application Scope activity has a property called “Visible” setting that property to False should solve the issue also you can use workbook activities which run in background without opening the excel application
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.