+ Reply to Thread
Results 1 to 2 of 2

Atomic Commit on Excle Files Used by Several People Simultaneously

  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    12

    Atomic Commit on Excle Files Used by Several People Simultaneously

    Hi,

    I know that this is not the right place for asking this question but I believe users of this forum must have experienced the same challenge in the past and can help me in dealing with the problem that I am facing.

    I have a spreadsheet , Excel 2007 format (.xlsx), that can not be loaded on Google docs due to size limitation and formula complexity. I tried SkyDrive too without any success. This file will be used by around 25 people during office timings and simultaneous access is inevitable.

    I looked at subversion but seems like that subversion will only keep revisions of a excel files i.e. It creates a unique file whenever a user make changes to a file and saves it. I am assuming that there will be hundreds of files in a matter of days.

    While doing research, I stumble upon a wikipedia page about Atomic Commit. Can anyone help me in finding a solution where all the users can access one files and whatever changes they make are kept in one single file.

    PS. All the 25 people have their own tabs to work and they will not work on other tabs.

    Thank you.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Atomic Commit on Excle Files Used by Several People Simultaneously

    in my opinion you would be well advised to use separate files for each user and then combine the data into a master workbook as required. or don't use excel-it is not good at multi-user operations even though it has a shared workbook feature.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1