Excel can refresh connection access file on shared network (1 Viewer)

Hi, i place my access file on shared network. Then i email my excel file to my colleagues. The problem is, only 2 pc can get data from access the other pc will prompt " Do you want to connect to..?" And asking for password etc. But i did not set any password.
I also tried tick allow trusted location on my network in access option.
Anyone have any idea? We are using win7 and access 2007