+ Reply to Thread
Results 1 to 2 of 2

Real Time Updates to a Shared Excel Call Log

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Office 2010

    Real Time Updates to a Shared Excel Call Log

    I have been working on a call log workbook with Excel 2010 that has two sheets: Sheet 1 is a call log form that has 4 fields to document call information then a save button on the bottom to run a macro that copies the data and pastes it into sheet 2 to log the information. I have tried sharing this workbook on the local network and making sure that all users can edit, but this does not allow real time updates, and does not allow everyone to input data unless someone allows their data to save or the others data to save in which causes their data to be visible or the others.

    I tried sharing this on OneDrive but since it is Excel 2010 it has to be opened via Excel on the desktop and not the web. I know that Access is the best route to take but my company doesn't want to pay for access for everyone in the office.

    Is there a way to share a workbook in excel with multiple people and have it save all users inputs and update real time?

    Is there anything in VBA that can be written to allow real time updates and to save all shared users changes without overwriting others changes?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    North Carolina
    MS-Off Ver

    Re: Real Time Updates to a Shared Excel Call Log

    Your company does not have to pay for Access for everyone in the office. The only people who need a full access license are the developers. Other people can use free, runtime-only licenses. The runtime-only license allows the user to run all existing reports, use existing queries and forms and do complete data update. The only thing they can't do is modify anything, or create anything new. This is probably what you want anyway.

    On the other hand. You can have an Access back end, and get to it from Excel without the need for any Access licensing at all. This works out OK if the people using the Excel spreadsheets are readers of the data. Without programming, they can't talk back to the data. If they merely need to see the latest information, then the built-in tool MS-Query can bring the data to them you can even pass parameters in case some people need some data and others other data. MS-Query has an option to refresh data every x minutes.

    Other schemes involve reading from and writing to CSV files, but there is a concurrency issue there. The last person to save wins!
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. [SOLVED] real-time excel clock
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2016, 08:23 PM
  2. excel live 60 min data real time
    By freak11 in forum Excel General
    Replies: 1
    Last Post: 06-08-2014, 08:20 PM
  3. Replies: 0
    Last Post: 05-14-2013, 02:00 PM
  4. excel as real time application.
    By yeshwant_sur in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2012, 11:24 AM
  5. Trouble Ticket system - shared workbook updates
    By gombi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2012, 04:54 PM
  6. Convert real time to a % in Excel
    By Barry in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 05:30 AM

Tags for this Thread


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