+ Reply to Thread
Results 1 to 2 of 2

Multiple users accessing Excel file on shared folder.

  1. #1
    Registered User
    Join Date
    04-04-2008
    Posts
    9

    Multiple users accessing Excel file on shared folder.

    I'm looking to have an excel file in a shared folder in a small network 5-10 users.

    1) If multiple users access the file at the same time, it will only save the user who saved the file last, correct? Is there any way around this?

    2) Is there any way of knowing that a user has the excel file opened? Is there a way to make it (in whatever way.. altering the folder, using excel, etc.) so that the user knows if another user has the file opened OR to block the user trying to access the already opened folder?

    Thanks in Advance!
    Dave

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Reply to Q1
    You can share a workbook so that multiple people can open it, alter it, save it

    This option is under the Tools menu > ShareWorkbook

    Reply to Q2
    If the workbook is not setup to be shared then the person will get a popup saying Filename is locked foe editing by users login id with the option to open in read only mode
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ 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