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?

Hi Andy,

This may be an issue with your network operatng system setup, rather than an Excel problem, per se. If it only affects some users, it might be worthwhile checking whether they're all using the same seeting under Tools|Options|General for 'ignore other applications'.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

By making this change will it affect the excel add-ons that we have running?

please advise - thanks

Hi Andy,

If some of the PCs have that option set and others don't, then any potential interaction with existing add-ins should already be evident.

Note: I wasn't saying to activate that setting on all PCs - only to check whether the problem PCs have it set the same as the ones that don't have the problem. If they're different, then changing the setting on the problem PCs may resolve the problem.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]