Do Not Lock while workbook is being saved

[Vick Dhanapal]

Hi All,

Is there a way to program not to lock the workbook while its being
saved.

The issue is, when someone tries to open the same file while its being
saved, excel prompts the read-only dialog box.

I would like to open it as read-only, automatically, when its locked
for saving.

Thanks, Vick

 

[Dave Peterson]

I don't know a way of changing excel's behavior, but if you don't care about
updating the workbook, why not always open it readonly mode.

Depending on the version of excel, you can rightclick on the filename (in the
File|open dialog) or use the dropdown arrow on the Open button of that file|open
dialog.