+ Reply to Thread
Results 1 to 3 of 3

Having excel doc open by multiple users without read only

  1. #1
    Registered User
    Join Date
    03-21-2010
    Location
    Kununurra, Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Having excel doc open by multiple users without read only

    We use an excel spreadsheet in the office and are wondering if it is possible for numerous people to be working on it at the samw time, and are able to save their work, ie not read only mode.
    Guessing not, but figured I'd ask.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,363

    Re: Having excel doc open by multiple users without read only

    Hello kimbcroc,

    welcome to the forum.

    Yes, you can do that. It's called sharing a workbook. But shared workbooks are extremely unstable, can freeze up any time and are prone to lose data. If you're happy to take this risk, then

    Open the workbook as the only current user
    click Tools - Share Workbook
    Tick the box "Allow changes by more than one user ..."
    Click the Advanced tab and adjust the settings there to your preferences.
    click OK and save the workbook.

    Now several users can access it and save changes at the same time.

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Having excel doc open by multiple users without read only

    Personally, I wish the option had never been invented!

    To quote and reinforce Teylyns' words

    .......shared workbooks are extremely unstable, can freeze up any time and are prone to lose data......
    For "prone" read "Guaranteed".

+ 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