Excel application scope how to save data keeping file open


I have an excel that needs to be open with admin rights and it has link to a desktop application.
It update data (dynamic price of stock)in the excel every 5 sec. I have to keep the excel open and pull data outof it.

Can you suggest how to save the excel without closing it.


You can use the Send Hot keys activity - Ctrl + ā€˜Sā€™ to save the file.
Make sure the focus is on Excel Window.

Karthik Byggari

Nopeā€¦ that will not work as the excel application scope will open the excel in read-only mode

By default the file will be opened in write-mode.
In the excel application scope, in the properties panel, disable Read-only if enabled.

You can even enable Auto-Save option in the Excel Application Scope to avoid explicitly saving the file.

Karthik Byggari

Nope!! i think you did not get the queries to open the excel i have to right-click and open as admin otherwise links in excel will be broken.

i already hve tried the send hot key. but my case excel will be open in read-only mode.

can you pls suggest

Before opening the file, can you try removing the read-only option. Right-Click on file ā†’ Properties-> Remove Read-Only.