Couldn't open excel file when data connection file is open!!

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!!

Excel_Error_msg.PNG

I got this error message when I refresh data connection on different computer. Any idea how to fix this?
Thanks!

If Auto-Filter is applied to data source, it can cause this issue. Check and see if removing this will fix the issue?
Basically, Excel creates hidden internal object to store filter information. These shouldn't be available normally, but when connector tries to retrieve worksheet names, these can appear and may cause issues.

And how exactly are you trying to bring in info? MSQuery, PowerQuery, other data connection etc?

Ok, so it's MSQuery based. You could also set option to remove system tables.