I need my users to open a certain spreadsheet from one shared location let
say L:\spreadsheet.xls
but for them to save their data on another location- let say their C drive.
And of course each time they open L:\spreadsheet.xls it will go and fetch
their data from their C drive.

Any idea?