We can not use linked table (to Excel) at the same time as two users!

[mezzanine1974]

I have a table which receives data from an Excel file which is located
under server (Same location with access database file). When two users
open this file, we can not use this table (linked to Excel file). I
mean the one who open the access file first can use data on that
table. But when second open and try to use that table, he fails.
Is there any way to fix this problem. We are twu users only and we
cant use it at the same time.
Thanks

 

[Klatuu]

In the Excel file that is the problem, try opening it and from the meny
select Tools, Share Workbook. Check the box on the Edit tab that says Allow
changes by more than one user at the same time.

I am not positive this will work, but it is a possibility.

 

[mezzanine1974]

First of all, I thank you Klatuu,

But i tried it before by myself but it is not working.