Opening Two Excel Files
I'm trying to open two different Excel files I need to work with. The first file opens fine at the beggining, then the second file opens and when it does, it turns the first file into "Read-Only" mode. I checked the settings and the action is NOT set to open as ReadOnly. Do you have any clues?
Many thanks in advance!
Actually I need both files open because there is a communication between them. That's why Closing the files is out of the question. So, the issue would be to open them both at the same time. So far I fixed it with: One file opening with the "Launch Excel" action and another one with the "Run Application" Action (linking to that particular file). I'm still looking for a more, let's say, elegant solution.
The only way we were able to reproduce the issue is when we open an Excel file and then open it again. In this case the second instance of the file opens as "Read Only".
Also, please make sure that before ending the process, you use the action "Close Excel", to close any open instances of Excel files.