Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get write access from read-onlly mode
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Read-Only Mode | Excel Discussion (Misc queries) | |||
Office Still Disabled - Read Only Mode | Setting up and Configuration of Excel | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) |