+ Reply to Thread
Results 1 to 2 of 2

Best way to share excel 2013 with multiple users

  1. #1
    Registered User
    Join Date
    06-06-2014
    Posts
    1

    Best way to share excel 2013 with multiple users

    Hi all!

    Currently my work uses google docs to simultaneously edit some tracking sheets for campaigns we are running, to help keep track of pacing and performance on a daily basis.

    The Google Doc works fine, but is very manual. I have created an Excel file that allows us to dump data in each day and automatically updates all fields for us, so we can really dive into the numbers instead of wasting time on the plug. Now the tricky part is how can I share this doc so that we can all make updates at the same time, and where do I store it?

    I have saved it in my Microsoft OneDrive and made it shareable, but when I e-mail the workbook to others, it isn't connecting them to the OneDrive version, but instead giving them a local option. How can I make it so we can all access it at anytime, from any computer - and also simultaneously make updates? Is this possible within excel or will we need to continue to use Google docs?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-16-2013
    Location
    Yorkshire
    MS-Off Ver
    Excel 2013
    Posts
    33

    Re: Best way to share excel 2013 with multiple users

    If you store the file on a shared network drive that others can access you can then send them a shortcut to the file. Excel 2013 has a share workbook option on the review tab that will allow users to make simultaneous edits.

    However, 'share workbook' comes with its own limitations (such as not being able to use Tables for starters) and can sometimes be quite prone to file corruption.

    If you're ok with the restrictions on it (list here ) then I'd say continue using it but take regular back-ups.


    Alternatively, if appropriate for your data set, you could try to departmentalize by having several different files for different people/departments that then all pool data into one master file.
    Last edited by -AJ-; 06-25-2014 at 05:51 PM.

+ 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. Share Sheets Excel 2013
    By gmcgrane in forum Excel General
    Replies: 1
    Last Post: 01-03-2014, 10:06 AM
  2. How to Share Workbooks between Multiple Users?!?
    By OliveMarie in forum Excel General
    Replies: 3
    Last Post: 10-24-2012, 06:22 PM
  3. Replies: 2
    Last Post: 08-22-2010, 02:40 AM
  4. Share with multiple users allowing macros
    By 19Rowy85 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2008, 06:14 PM
  5. multiple users- Share workbook
    By kizzie in forum Excel General
    Replies: 2
    Last Post: 04-03-2008, 04:03 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