+ Reply to Thread
Results 1 to 5 of 5

2 people opening the same spreadsheet at the same time

  1. #1
    Forum Contributor
    Join Date
    07-26-2017
    Location
    west midlands
    MS-Off Ver
    365
    Posts
    182

    2 people opening the same spreadsheet at the same time

    Hi all,
    How do I allow more than one person into a spreadsheet, make changes AND save if I am also in the same sheet at the same time?

    Thanks all.
    Tony

  2. #2
    Registered User
    Join Date
    01-31-2019
    Location
    Midlands
    MS-Off Ver
    2016
    Posts
    13

    Re: 2 people opening the same spreadsheet at the same time

    Share the workbook - be warned though, Shared workbooks have been known to be difficult in a workplace environment.
    (file size, network stability etc)

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: 2 people opening the same spreadsheet at the same time

    Check this: https://www.ablebits.com/office-addi...ultiple-users/
    Click the * to say thanks.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: 2 people opening the same spreadsheet at the same time

    Hi Tony,

    Newer versions of Excel 365 have improved this feature.

    https://support.office.com/en-us/art...b-3024e46fb104

    I'd also look at keeping the file on a OneDrive and see if that does what you need.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Contributor
    Join Date
    07-26-2017
    Location
    west midlands
    MS-Off Ver
    365
    Posts
    182

    Re: 2 people opening the same spreadsheet at the same time

    Thanks guys, You have answered my question and solved my problem. Brilliant!!

+ 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. Marco to show people who have entered the spreadsheet
    By vba1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2016, 02:26 PM
  2. [SOLVED] Can I automate the duplication of a spreadsheet for 92 different people?
    By CHillFL in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 09-04-2015, 03:06 PM
  3. Replies: 5
    Last Post: 05-30-2014, 04:53 AM
  4. Need help with a spreadsheet I want people to see on the web
    By pglufkin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2013, 05:28 PM
  5. 2 people working on the same spreadsheet?
    By burnsie in forum Excel General
    Replies: 2
    Last Post: 01-14-2013, 11:36 AM
  6. Stop people pasting in to a spreadsheet
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 01-04-2011, 06:46 AM
  7. [SOLVED] ASP Page not opening a new Excel Spreadsheet each time.
    By lds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2006, 04:20 PM

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