help with network users

i doubt it! best you just email everyone telling them to open the latest version and not use their current locally stored copy.

in the good old days of DOS i'd add a batch file to each users start up folder which would copy the latest version across. Only problem with that is it would overwrite the users local copy everytime they reboot. Not so handy if they want to keep their own changes, but then again they can always "save as" if they want to keep their own version going.

A batch file would look something like this, though it's been a while so you might have to tweak it.

** C:\targetfoldername\
copy G:\serverfoldername\filename.xls /y

The first line changes to the directory or folder you wish the file to go to on the target machine.
The second line copies the file from the server location and overwrites the existion version.
The /y stops the confirm overwrite prompt.
Obviously change the paths to suit your file locations.
Save that as a .bat file in the start up folder on each PC.

I'm sure there'd be ways of doing this by using registry entries too but I'm not up to speed with that.

PS the two * above are a c and a d with no space. For some reason this board wont let me write that ?????