ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Editing in a multi-user environment (https://www.excelbanter.com/excel-discussion-misc-queries/75103-editing-multi-user-environment.html)

Daverob

Editing in a multi-user environment
 
Can anyone help please.

I have a shared workbook which is to be used as a booking diary, is there
any way that editing a cell by more than one user can be stopped. I know
that changes can be tracked, but my understanding is they only show up when
the last person saves the file.

Any help would be appreciated.
--
daver

keithl816

Editing in a multi-user environment
 

You can go into properties/security for that workbook and change the
user settings.

Or protect the cells that you do not want altered.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=518731


Hernandez, Roberto

Editing in a multi-user environment
 
Or/and create a 'log' file, to record changes in your book, by VBA code.

"Daverob" escribió en el mensaje
...
Can anyone help please.

I have a shared workbook which is to be used as a booking diary, is there
any way that editing a cell by more than one user can be stopped. I know
that changes can be tracked, but my understanding is they only show up
when
the last person saves the file.

Any help would be appreciated.
--
daver





All times are GMT +1. The time now is 04:13 PM.

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