Excel Add-In - Not allowing shareable file in Access Database

[sjj0133]

We have a handful of users that are having issues with the Add-In tool. This tool has been in place for over 10 years and we never had issues until this year. The Excel Add-IN tool pulls multiple scenarios of data within this add in. But one specific part of it access a file YM.accdb, an access database. When trying to do an item search, some users are getting the Data Link Properties Box and anything we enter there does not work. I have done a variety of test, and it looks like it is a shareable issue. So if I have all users out of the YM.accdb database, it will work for the users that have issues….only if there is not a user lock on the YM.accdb. I did check all the appropriate shareable settings in Excel. But I want to note, it works for the 30 other users when there is a lock on the database. Why are there 3 users that have this issue but the other 30 issues can access the file when someone else is querying against the same database? Every week appears I get another user that comes up with the same issue. There are no limitations of users that we exceed on the folder.