The file is designed for another (1) user to update a bunch of data in the
file. Once they are done, they save it and then I use it for other
functions. We've thought about using Access, but its too late in the game to
use at this point in time.

I'm looking to see if there is a way to prevent them from oversaving a file.

"Edmund" wrote:

What sort of data is in the file? I ask becuase it sounds like this may be
better suited to a database (eg. MS Access). If multiple users need to
access/update the data then perhaps it is not a good idea to use a system
that is not designed for such. A database is designed to do just that. Can
you put it into a database?

Oh, I just though of something. Did you know that you can link the Excel
file as a table in an Access database. I think each sheet can be linked as
a table. Then you could use the Form Wizzard to create forms to access the
linked tables (that are really the excel pages). That way if you really
needed the data in Excel, say, for some macro or charting, then it can stay
in Excel; while the access is controlled by Access.

Edmund


"CCrew2000" wrote in message
...
Problem is that I want them to be able to open the file, make changes and
save it at that time. If they "save as" the file to another location,
then
there are now two versions of the file. This could cause issues down the
road.

I'd like to be able to protect the file to prevent it from being saved
over.
Have it ask for a password or something along those lines. I already have
a
password in order to open the file.

"Edmund" wrote:


Set the file as read-only. Or you can get the System Administrator to
make
that network folder read-only, since savy users will simply set the file
to
read-write and then save over it (if any of your users are that savy).

"CCrew2000" wrote in message
...
Is there a way to prevent someone from saving over a specific file?

I've created a file on a network drive for some users. Some of the
users
complain about the time it takes to open the excel file. What they've
done
is save the file to their C:\ once the file is open. Make their
changes
and
then "save-as" back to the network drive (thus overwriting) the
original
file.

How can I prevent them from saving over my file with their "new" file?