+ 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
    67
    Thank Post
    16
    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,498
    Thank Post
    1,488
    Thanked 1,049 Times in 918 Posts
    Rep Power
    301
    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
    21
    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,332
    Thank Post
    1,380
    Thanked 851 Times in 544 Posts
    Rep Power
    640
    Google Apps?

  5. #5
    budgester's Avatar
    Join Date
    Jan 2006
    Location
    Enfield, Middlesex
    Posts
    485
    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
    67
    Thank Post
    16
    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
  •