Not getting notification of file lock Excel

[Gizmo3k]

Hi,

I hope someone can help me. I have some spreadsheets which are on a shared network drive, and are accessed by multiple users, across multiple domains and sites. We are using a mixture of Office 2000, Office XP and Office 2007. There might be some Office 97 in there too!

For some reason, users don't get notification that the file is locked for editing if the person who is already in the file based on another domain or site.

Does anyone know why this might happen?

If this is something which 'just happens', does anyone know any easy way to manually check if there is another user in the sheet? I don't mind implementing some sort of VBA solution on the sheet, if someone can point me in the right direction!

Thanks,

Gizmo3k

 

[SkipVought]

Hi,

Are these workbooks designated as SHARED in Tools > Share Workbook...?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gizmo3k]

Hi Skip,

These workbooks are not defined as shared. They are on a shared network drive (trusts exist between all the different domains).

I tried setting one of the sheets to 'Shared' a while ago, however it was taking anything up to a minute to open the sheets, and the added functionality didn't seem too reliable!

cheers

Gizmo3k