A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
If multiple users are using a shared workbook with mulitple tabs, is it possible to make active tabs read only to everyone else?
So say I go into a worksheet first, to other people this will appear read only until I go to another worksheet, preventing people from updating the same tab at the same time and overwiritng eachothers information.
I'm open to any better suggestions...
|
Gary
Premium Member
Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
|
Tell them not to update anything.
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
Probs easier all round to make each tab an individual document.
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
quote: Originally posted by Brett
Probs easier all round to make each tab an individual document.
Thats what they asked me for originally, I could do a summary workbook that pulls it all together, just wondered if there was an easier way.
I've said that ideally they need to be using Access.
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
I suffer the same problems here. We have to input numbers in a spreadsheet and I've made it shared in the past, but one girl working for me is so fucking retarded and since it limits some functionality it did more harm than good and just caused me ear ache. Ended up seperating them and doing a summary workbook like you suggested.
|