+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, Collaborating Excel data in Technical; Morning, Am I right in saying that having 30 students all opening and editing 1 single excel file is not ...
  1. #1
    Obzen's Avatar
    Join Date
    Dec 2008
    Posts
    69
    Thank Post
    18
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Collaborating Excel data

    Morning,

    Am I right in saying that having 30 students all opening and editing 1 single excel file is not best practice?

    I've got a IT Teacher doing this right now and he is having problems with it being slow... which I think is about right. Is there a right or wrong way to do this type of exercise?



    Thanks!

  2. #2

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,399
    Thank Post
    1,516
    Thanked 1,056 Times in 925 Posts
    Rep Power
    303
    Have they set it up as a shared workbook?

    Share a workbook - Excel - Office.com is a rough guide from MS. It doesn't have to be stored on SharePoint either just in a shared drive.

    I used that way with various things and it wasn't too bad, occasional glitches but it did the job.

  3. #3

    Join Date
    Oct 2013
    Location
    Hampshire
    Posts
    26
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Short answer - yup.
    Single xl file amongst 30 users - not best practice. TBH we would have problems when we had 3 IT staff working on a shared xl file on a gigabit ethernet, losing the current active shared token was the biggest problem. Lockouts were the other...

    We eventually moved it to a database solution - even a basic database will allow multiuser access.
    What hard/software do you have available?

  4. #4


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,463
    Thank Post
    1,462
    Thanked 891 Times in 572 Posts
    Rep Power
    647
    Google Apps?

  5. #5
    budgester's Avatar
    Join Date
    Jan 2006
    Location
    Enfield, Middlesex
    Posts
    486
    Thank Post
    4
    Thanked 37 Times in 30 Posts
    Rep Power
    24
    30 people opening and reading is bad enough, nut editing as well, it's not gonna end well.

    Why do people teachers even think this might be a good idea, let alone IT Teachers...

  6. #6
    Obzen's Avatar
    Join Date
    Dec 2008
    Posts
    69
    Thank Post
    18
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for the replies, I've directed my teacher to use Google docs. I'm just waiting for the ole "well I did it in my old school!!!!"

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2010] Issues appending Excel data to Access Table
    By CHR1S in forum Office Software
    Replies: 6
    Last Post: 7th August 2012, 07:43 AM
  2. [MS Office - 2007] Excel Data Sorting
    By bodminman in forum Office Software
    Replies: 1
    Last Post: 26th March 2012, 12:28 PM
  3. Problem with date when merging excel data in word
    By CatherineMay in forum AV and Multimedia Related
    Replies: 1
    Last Post: 6th July 2011, 03:39 PM
  4. Datacable or Excel Data Services?
    By harvy28 in forum Hardware
    Replies: 2
    Last Post: 28th April 2008, 11:32 AM
  5. Excel Assesment Data
    By danIT in forum General Chat
    Replies: 2
    Last Post: 14th February 2008, 02:14 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •