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.
Bookmarks