Hi guys,

I have been using data connections to link to other Excel files on the network drive.

I do this by clicking on "Existing Connections" and then "Browse for More.." and then I would browse to my Excel file with the other data.

This has worked really well for me over the past years and I prefer this over referencing to other Excel files (i.e. =[test1.xlsx]Sheet1!$B$16)

However there is one thing I would like to some help on:

When I refresh my connections by clicking on "Refresh All", the data would be refreshed without a hitch, however the source file becomes open and no one else can edit the file.

This is quite problematic other people need the file while I have my datasheet open.

Is there anyway to make it read-only? I've tried disabling "Enable background refresh", but the file still stays open.