Hi,
i've just started a new job today and i introduced shared workbooks to the office but I have a problem which has caused me to have some egg on my face..
S)
I have a shared workbook on a network and when there is a conflict, Excel doesn't ask my permission.
The shared workbook settings are:
-keep change history for 30 days
-updates changes when file is saved
-ask me when changes win
when there is a conflict (when someone deletes the contents of a cell and repopulates it) and we both save it just comes up with:
"workbook has been updated" instead of asking me, (the person who set up the workbook as a shared workbook).
Does anyone know how to resolve this issue please?
Many thanks,
Paddy
i've just started a new job today and i introduced shared workbooks to the office but I have a problem which has caused me to have some egg on my face..
S)I have a shared workbook on a network and when there is a conflict, Excel doesn't ask my permission.
The shared workbook settings are:
-keep change history for 30 days
-updates changes when file is saved
-ask me when changes win
when there is a conflict (when someone deletes the contents of a cell and repopulates it) and we both save it just comes up with:
"workbook has been updated" instead of asking me, (the person who set up the workbook as a shared workbook).
Does anyone know how to resolve this issue please?
Many thanks,
Paddy
