User opening files in Excel 2003

[andy]

Hi,

We have various Excel spreadsheets that are used by various users to complete there everyday tasks - however of recent the users are starting to experience some issues, which are:



There can be 2 users logged into a spreadsheet at any given time however only 1 user can save, while the other user will loose there work, which can be frustrating. The spreadsheet is setup so only 1 user can save at a time, however when the user opens the spreadsheet it is not prompting them, that there is already another user working on the same spreadsheet.

Any ideas?