Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
I create a spreadsheet and save it. When another user opens the file and
makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
Sounds like the workbook has been saved as a "read-only recommended" file.
Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
I checked this and the file was not saved as a read only. Also when you or
someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
What are the permissions on the folder the file resides in?
rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
From what I can tell there are none. No restricted or unrestricted. Does
this help? "Bob I" wrote: What are the permissions on the folder the file resides in? rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
Everyone, Full permission?
rmold524 wrote: From what I can tell there are none. No restricted or unrestricted. Does this help? "Bob I" wrote: What are the permissions on the folder the file resides in? rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
I go to the File tab and there is no Persmission tab under it. In other
searches the spreadsheet does not appear to be protected/restricted in any way. Is there another area to look for the Permission tab? Or anything? "Bob I" wrote: Everyone, Full permission? rmold524 wrote: From what I can tell there are none. No restricted or unrestricted. Does this help? "Bob I" wrote: What are the permissions on the folder the file resides in? rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
No that would be the Folder properties, Security tab.
rmold524 wrote: I go to the File tab and there is no Persmission tab under it. In other searches the spreadsheet does not appear to be protected/restricted in any way. Is there another area to look for the Permission tab? Or anything? "Bob I" wrote: Everyone, Full permission? rmold524 wrote: From what I can tell there are none. No restricted or unrestricted. Does this help? "Bob I" wrote: What are the permissions on the folder the file resides in? rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
I did a right click on the icon and went the to the security tab. Here I
gave all users full access and this allows users to make changes and then save under the same name. Thanks. "Bob I" wrote: No that would be the Folder properties, Security tab. rmold524 wrote: I go to the File tab and there is no Persmission tab under it. In other searches the spreadsheet does not appear to be protected/restricted in any way. Is there another area to look for the Permission tab? Or anything? "Bob I" wrote: Everyone, Full permission? rmold524 wrote: From what I can tell there are none. No restricted or unrestricted. Does this help? "Bob I" wrote: What are the permissions on the folder the file resides in? rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing and saving worksheet
You're welcome, have a good day.
rmold524 wrote: I did a right click on the icon and went the to the security tab. Here I gave all users full access and this allows users to make changes and then save under the same name. Thanks. "Bob I" wrote: No that would be the Folder properties, Security tab. rmold524 wrote: I go to the File tab and there is no Persmission tab under it. In other searches the spreadsheet does not appear to be protected/restricted in any way. Is there another area to look for the Permission tab? Or anything? "Bob I" wrote: Everyone, Full permission? rmold524 wrote: From what I can tell there are none. No restricted or unrestricted. Does this help? "Bob I" wrote: What are the permissions on the folder the file resides in? rmold524 wrote: I checked this and the file was not saved as a read only. Also when you or someone else opens the file it did not state the file was a read only and that you could not make changes to it. Any other suggestions? "Gord Dibben" wrote: Sounds like the workbook has been saved as a "read-only recommended" file. Have a look at FileSave AsToolsGeneral Options and clear that checkbox and re-save. Gord Dibben MS Excel MVP On Fri, 28 Sep 2007 14:31:01 -0700, rmold524 wrote: I create a spreadsheet and save it. When another user opens the file and makes changes they cannot save under the same name. They have to save as "copy of." What do I need to change so that they can make changes and save under the same name in the same directory? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing the target worksheet | Excel Discussion (Misc queries) | |||
How do I go directly to editing a worksheet in excel? | Excel Discussion (Misc queries) | |||
editing an excel 97 file within excel 2003 and saving back as exce | Excel Discussion (Misc queries) | |||
Worksheet locked for editing | New Users to Excel | |||
What do I need so I can open an Excel worksheet for editing? | Excel Worksheet Functions |