+ Reply to Thread
Results 1 to 2 of 2

Excel allowing two users to simultaneously access a non-shared workbook?

  1. #1
    Registered User
    Join Date
    08-29-2019
    Location
    Minerva, OH
    MS-Off Ver
    2007
    Posts
    1

    Excel allowing two users to simultaneously access a non-shared workbook?

    I think my boss might have just made a bunch of edits to our workbook in Read-Only mode, and not realized it.
    This has been happening for several months, sporadically. However, I'd like to parse this thing out for any real issues we might be facing.

    So here's how the story goes:

    Boss opens up a workbook living on a Network server first thing in the morning, keeps it open all day making edits. Only has it open all day like this once or twice a week.
    Meanwhile, I am able (supposedly) to open the workbook, not Read-Only --- but in write-mode! I'm inputting data, saving and closing without an issue.

    Near the end of the day, he pops in to ask what happened. He says when he went to save, Excel notified him that it was Read-Only.

    Now my questions is, is that possible?
    That is, open a spreadsheet in write-mode, only to be later notified by Excel that it's Read-Only?
    (Nevermind that he didn't save a copy and instead redid his work from scratch, which didn't make any sense to me)

    I've come up with a couple of possible explanations (which might not make any sense, I'm not an Excel wizard):
    1. That the Workbook is "Shared" on his instance of Excel, but not mine, somehow ("Remove" box checked in Trust Center)
    2. That a remote access User (from our corporate offices in Chicago, IL) could be opening this workbook, affecting it somehow.

    Any input would be greatly appreciated.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Excel allowing two users to simultaneously access a non-shared workbook?

    First of all two persons simultaneously cant work with a single file without sharing.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Multiple Users Access Workbook Simultaneously ?
    By Logit in forum Excel General
    Replies: 3
    Last Post: 05-18-2018, 01:36 PM
  2. Macro for allowing access for users to click buttons when sheet is protected
    By targus92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2016, 12:29 PM
  3. Error Handling - Shared Spreadsheets (2 users saving simultaneously)
    By Smurlos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 05:42 AM
  4. Replies: 2
    Last Post: 06-20-2012, 07:38 AM
  5. multiple users to access and edit on the protected shared workbook
    By hyee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2011, 03:50 AM
  6. how to limit edit access to certain users for a shared workbook?
    By Pam Deshazier, SRHS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2005, 01:30 PM
  7. Shared workbook only allowing read-only access
    By macmac77 in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:17 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