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 ...
13th February 2014, 11:52 AM #1
Collaborating Excel data
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?
13th February 2014, 12:14 PM #2
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.
14th February 2014, 05:55 AM #3
- Rep Power
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?
14th February 2014, 06:06 AM #4
14th February 2014, 07:57 AM #5
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...
25th February 2014, 09:25 AM #6
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!!!!"
By CHR1S in forum Office Software
Last Post: 7th August 2012, 07:43 AM
By bodminman in forum Office Software
Last Post: 26th March 2012, 12:28 PM
By CatherineMay in forum AV and Multimedia Related
Last Post: 6th July 2011, 03:39 PM
By harvy28 in forum Hardware
Last Post: 28th April 2008, 11:32 AM
By danIT in forum General Chat
Last Post: 14th February 2008, 02:14 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)