+ Reply to Thread
Results 1 to 17 of 17

Simultaneous Update

Hybrid View

arlu1201 Simultaneous Update 02-27-2012, 05:48 AM
Domski Re: Simultaneous Update 02-27-2012, 06:52 AM
Mordred Re: Simultaneous Update 02-27-2012, 07:12 AM
arlu1201 Re: Simultaneous Update 02-27-2012, 07:15 AM
Mordred Re: Simultaneous Update 02-27-2012, 07:18 AM
arlu1201 Re: Simultaneous Update 02-27-2012, 07:26 AM
OnErrorGoto0 Re: Simultaneous Update 02-27-2012, 07:44 AM
arlu1201 Re: Simultaneous Update 02-27-2012, 07:49 AM
OnErrorGoto0 Re: Simultaneous Update 02-27-2012, 07:50 AM
arlu1201 Re: Simultaneous Update 02-27-2012, 07:51 AM
OnErrorGoto0 Re: Simultaneous Update 02-27-2012, 07:57 AM
arlu1201 Re: Simultaneous Update 02-27-2012, 08:03 AM
snb Re: Simultaneous Update 02-27-2012, 08:11 AM
arlu1201 Re: Simultaneous Update 02-27-2012, 07:58 AM
OnErrorGoto0 Re: Simultaneous Update 02-27-2012, 08:00 AM
OnErrorGoto0 Re: Simultaneous Update 02-27-2012, 08:11 AM
Mordred Re: Simultaneous Update 02-27-2012, 08:12 AM
  1. #1
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Simultaneous Update

    Never ever ever ever ever ever ever ever ever ever use Shared Workbooks. Unless your life is boring and needs livening up.
    Good luck.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Simultaneous Update

    Thats what i thought. If they dont know Access, they will have to choose other options....not provided by Office.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Simultaneous Update

    In many cases this will do in Excel:

    If all users can only open a copy of a central workbook : Worbooks.add "\\central.xls"

    You only have to provide for a small macro to save the modifications made by each user in the copyfile into the common workbook "\\central.xls"
    The opening of the common file, the adaptation with the modifications and the saving of the common file will only last milliseconds if performed by a macro.
    The chance of multiuser interference will be minimal.

    Especially if you allow users only to use userforms to change anything you can have a very standardized structure of the data in Excel.
    Everyone who has read-only access to the common file will also only be provided with a copy of it.

    There are a lot of organizations that have no trillion employees working with the same data simultaneously.
    Last edited by snb; 02-27-2012 at 08:15 AM.



+ 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