corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Shared Workbook


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Shared Workbook
A2H GO
Member

Registered: 14th Sep 04
Location: Stoke
User status: Offline
10th Aug 12 at 09:55   View User's Profile U2U Member Reply With Quote

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

Avatar

Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
10th Aug 12 at 10:25   View Garage View User's Profile U2U Member Reply With Quote

Tell them not to update anything.
Brett
Premium Member

Avatar

Registered: 16th Dec 02
Location: Manchester
User status: Offline
10th Aug 12 at 10:44   View Garage View User's Profile U2U Member Reply With Quote

Probs easier all round to make each tab an individual document.
A2H GO
Member

Registered: 14th Sep 04
Location: Stoke
User status: Offline
10th Aug 12 at 11:21   View User's Profile U2U Member Reply With Quote

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

Avatar

Registered: 16th Dec 02
Location: Manchester
User status: Offline
10th Aug 12 at 11:31   View Garage View User's Profile U2U Member Reply With Quote

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.

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
is there a program that...... chris_uk Geek Day 6 1893
16th Jun 05 at 00:47
by Dan B
 
Excel help Edd Geek Day 2 166
20th Nov 07 at 14:47
by Edd
 
Anybody a bit of a geek in Excel and bored at work? A2H GO Geek Day 8 772
13th Aug 09 at 20:30
by Dom
 
Excel Locked down? A2H GO Geek Day 2 285
27th Oct 11 at 18:42
by A2H GO
 
Excel Question, linking column to cell Russ Geek Day 9 226
5th Jul 12 at 15:36
by Russ
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Shared Workbook 29 database queries in 0.0135951 seconds