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?

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?

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?

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?

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?

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?

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?

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?

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?

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?