I'm creating an excel data connection of a release log, which will be will be kept open 24/7 displayed remotely and refreshes automatically every 5 minutes so it can display the latest info entered in to the original excel file (release log). Everything is working fine except I'm facing the problem when I need to open the original excel file it gives a message "file locked by another user" and can be only opened in read-only mode which doen's help for the purpose. I found that this problem occurs after the data connection is refreshed. Can anyone please tell if there is a way to overcome this issue?. All I wanted is to be able to open the original excel file any time I wanted, enter the data, save and close it without interfering the data connection file. Thanks in advance for your help!!
Bookmarks