how to get write access from read-onlly mode

M

Maus

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?
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top