This is probably very simple, but i have a quick question.

I have a spreadsheet on a public network drive. At the end of the day,
people are to copy their information from their local machines to this
public
spreadsheet.


How do I prevent 2 people accessing the file at the same time ie just
prevent the update happening etc until it's 100% available?

If a user opens a file which is already open (like by another user) then
Excel will pop up a warning, and only allow the file to be opened read only.
So what you actually have to do is work out how to coordinate everyone into
opening the workbook at seperate times.

Iain King