Sorry not explained myself properly!

The .xlsm file pulls data from MS Access Query within excel.

What happens when we try to refresh the data it works on a couple of our machines, but on the others it pops up asking for a login name and password?

The file/database has no passwords so confused.com!!

Hope this explains it better!

Martyn