ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   want to 'share' a workbook but Says Read only'when others try save (https://www.excelbanter.com/excel-worksheet-functions/51878-want-share-workbook-but-says-read-onlywhen-others-try-save.html)

Danielle

want to 'share' a workbook but Says Read only'when others try save
 
I am trying to make a work book 'shared' so other people can open it up and
make changes etc..then save it. But every time another user then goes to open
the work book, it comes up 'read only'. I have ticked the box that says
'Allow Changes by more than 1 user at the same time' but that does not seem
to have any effect. What am I forgetting?

ramana

want to 'share' a workbook but Says Read only'when others try save
 
Hi Danielle,

You check Tools -- Options -- Security -- Uncheck the button
Readonly Recommended.

Regards

Ramana

Danielle wrote:
I am trying to make a work book 'shared' so other people can open it up and
make changes etc..then save it. But every time another user then goes to open
the work book, it comes up 'read only'. I have ticked the box that says
'Allow Changes by more than 1 user at the same time' but that does not seem
to have any effect. What am I forgetting?



Danielle

want to 'share' a workbook but Says Read only'when others try
 
Thanks for replying....But that box is not 'checked' in the first place??
What else could I be missing? I can not work out why I cannot share
workbooks with the ability for others to save an update. It still keeps
saying 'Read only' whicj defeats the purpose of Sharing a workbook?

"ramana" wrote:

Hi Danielle,

You check Tools -- Options -- Security -- Uncheck the button
Readonly Recommended.

Regards

Ramana

Danielle wrote:
I am trying to make a work book 'shared' so other people can open it up and
make changes etc..then save it. But every time another user then goes to open
the work book, it comes up 'read only'. I have ticked the box that says
'Allow Changes by more than 1 user at the same time' but that does not seem
to have any effect. What am I forgetting?





All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com