+ Reply to Thread
Results 1 to 2 of 2

Excel as Time Keeping Sheet- multiple users create conflicted copies

  1. #1
    Registered User
    Join Date
    01-20-2021
    Location
    Tupelo, Mississippi
    MS-Off Ver
    18.2008
    Posts
    1

    Excel as Time Keeping Sheet- multiple users create conflicted copies

    I have created an Excel to allow the member of my small company (8) to record their working hours. I have drop down lists and an ActiveX Command Button that stamps the immediate time in the active cell. My problem is that the excel is shared through DropBox and when multiple employees have it opened, the excel saves itself as conflicting copies of the same workbook. I want all of the information to be kept on the one shared Master Excel. Is there any way to do this?
    Thanks!

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Excel as Time Keeping Sheet- multiple users create conflicted copies

    Have you tried the old "Shared Workbook" feature, now known as "co-authoring" in Excel 365?

    https://www.google.com/search?q=exce...-8&safe=active


    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to create multiple copies of a sheet, copies named based on list in other sheet
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2019, 02:40 AM
  2. [SOLVED] Macro that copies a formula to another sheet and copies data at same time
    By Newbienewbster0932 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2017, 02:49 PM
  3. Hi all, i need help, how to create Login sheet with multiple users
    By jagankumarrohini in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-24-2014, 12:20 AM
  4. Replies: 2
    Last Post: 04-17-2014, 09:41 PM
  5. need help to create multiple copies of sheet for different sales reps
    By mdias815 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2006, 12:30 PM
  6. [SOLVED] why does excel create multiple copies (as many as 18) of a file?
    By Beezie in forum Excel General
    Replies: 6
    Last Post: 08-11-2005, 11:05 AM
  7. [SOLVED] Why does Excel create multiple copies of the same file?
    By TJRUFF in forum Excel General
    Replies: 2
    Last Post: 01-27-2005, 05:06 PM

Tags for this Thread

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