.csv is about as far away as you can get from a multi-user file format: if you are playing with the file in a link, whatever process tries to update the file risks disapointment.
if you must use .csv, i think you are going to need a refresh-data button and import (not link) the .csv (with appropriate loops and error trapping in case the .csv is currently locked in an update process).
Earth | North America | United States | California | Long Beach
I understand your point about the locking. Although I believe that the owner updates the file on her desktop and then ftps the file to the Intranet location. Ahh but now as I write that comment, I see your point, she may not be able to overwrite the file if I am viewing it.
So...the refresh data button is the best idea at this point.
Can you help me with the code that would grab this csv from a web address (Intranet address)?