Login to Account Create an Account
Excel write access by 2 users
Posted 04 May 2013 - 11:27 AM
Is there some way to fix this so both users have get read/write access at the same time please? They are both taking telephone calls, and want to update a booking calendar spreadsheet in real time.
Posted 04 May 2013 - 12:47 PM
PersonA and PersonB both open FileCopyA for Update.
PersonA Changes and Updates which creates FileCopyB.
PersonB Changes and Updates which creates FileCopyC.
Changes made by PersonA to create FilecopyB are lost due to PersonB Changes.
This type of scenario is STOPPED in a Mainframe environment in the same way by using Enqueue/Dequeue (Lock/Unlock) techniques and a Comparison Routine to ensure overwrite/dataloss does not occur AT THE LINE ITEM (RECORD) LEVEL and NOT at the Whole File Level.
Your only option is to have BOTH Persons with their OWN copy and Compare/Merge Changes later.
Please understand that each person is working at the File Level and NOT on the Line Item Level. That's why they invented DataBases. Maybe you should change to using an SQL Database?
edit - Also note that MS INTENTIONALLY did that for the very reason I gave above.
Edited by submix8c, 04 May 2013 - 12:49 PM.
Posted 04 May 2013 - 01:25 PM
There is a situation at work where 2 users need simultaneous write access to the same excel spreadsheet on the LAN.
There is a situation at your workplace where the only solution devised for a problem has been that of having two users access the same spreadsheet simultaneously.
You are slipping on a chocolate covered banana :
And now, for some recreational Zen, let me cite Master Foo (actually Sean Mc Grath):
... databases are Rocks spreadsheets are Water ...
Edited by jaclaz, 04 May 2013 - 01:35 PM.
Posted 04 May 2013 - 01:43 PM
Update: I have found this here:
but it looks quite complicated to set up to me. This may be useful to somebody else.
Edited by JedClampett, 04 May 2013 - 10:48 PM.
Posted 05 May 2013 - 05:25 AM
(just examples), more here:
would do for your problem.
Posted 06 May 2013 - 04:25 AM
Posted 06 May 2013 - 06:03 AM
Most probably you can also "cross-link" the two files.
Thanks for those links jaclaz. I'll take a look at them soon. I don't like the idea of using an excel spreadsheet like a database either. As a temporary measure, what if the current spreadsheet was split into two seperate sheets? That way one of the operators can have half of the contractors in their own spreadsheet, and the other call operator can have the other half of the contractors in their spreadsheet. They can both have read/write access then without getting locked out from making updates to their calendars.
I have NO idea how currently your spreadsheet is made and how the data is input in that, but check the attached Calendar1.xls and Calendar2.xls.
(of course just an example) when some data is entered in calendar1 the corresponding cell in calendar2 becomes red....
Just a basic idea, then you might need a third spreadsheet to "merge" the calendar of the first two (at the end of the day).
Posted 27 June 2013 - 01:52 PM
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users