G
Gavin
I've created a Shared Workbook on a network drive.
Normally it works fine, but sometimes when opening it,
Excel shows the message:
"File is Locked. In order to save changes to the file,
you can either close the file before making any changes
and then re-open it, use Save-As to save the file using
another Filename, or turn off Shared Workbooks and then
save the file."
BUT after clicking OK I can't do anything. I can't even
close the file - I have to shutdown Excel.
I have checked that nobody else on the network is even
working on that file at the time. This could go on for
days and then suddenly it starts working again, but
usually I just the IT dept to restore a backup.
I have had this problem with other shared workbooks as
well, so it is not just this file.
Normally it works fine, but sometimes when opening it,
Excel shows the message:
"File is Locked. In order to save changes to the file,
you can either close the file before making any changes
and then re-open it, use Save-As to save the file using
another Filename, or turn off Shared Workbooks and then
save the file."
BUT after clicking OK I can't do anything. I can't even
close the file - I have to shutdown Excel.
I have checked that nobody else on the network is even
working on that file at the time. This could go on for
days and then suddenly it starts working again, but
usually I just the IT dept to restore a backup.
I have had this problem with other shared workbooks as
well, so it is not just this file.