View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default how to get write access from read-onlly mode

In short the answer is no... When you open up a read only file what is
happening in the background is that a temporary copy of the original file is
created and opened. In that way when you want to save you can not overwrite
the original as you never opened the original. If you try to save the file
overtop of the read only file that will not work either as you can not save
over top of a read only file.
--
HTH...

Jim Thomlinson


"Maus" wrote:

Can anybody tell me if it is possible after opening an excel sheet in
readonly mode to switch to write mode?

to be more specific.
I have a schedule in the team with a password to modify.
if someone else has it open for writing, I can choose at opening for
notify.
the moment the other person closes the sheet, I get a message and the
possibility to login with the pw, without closing the sheet first.
Now I wonder if this is also possible when I open the sheet (only me,
nobody else) choose for Readonly and then later I want to switch to
write, whitout having to close the sheet.

Is this possible?