+ Reply to Thread
Results 1 to 3 of 3

Is "protect and share" the workbook necessary if workbook is on a network share drive?

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2013
    Posts
    81

    Is "protect and share" the workbook necessary if workbook is on a network share drive?

    Is "protect and share" the workbook necessary if workbook is on a network share drive?

    I want to ensure that anyone who views it can see real time changes as well as be able to have multiple people updating it and viewing it at the same time.

    I can't find a clear answer anywhere.

    Thanks!

    Nate

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Is "protect and share" the workbook necessary if workbook is on a network share drive?

    Protect and Share allows you to have control over what is open for amendments and what is not. Lock the cells that you don't want changeable and unlock those that can be changed then protect the worksheet(s).
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    06-18-2013
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2013
    Posts
    81

    Re: Is "protect and share" the workbook necessary if workbook is on a network share drive?

    thanks! that worked

+ 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. "Save as" Macro to Network share
    By pjw23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2011, 08:50 AM
  2. Replies: 4
    Last Post: 04-24-2006, 02:00 PM
  3. [SOLVED] "Share Workbook" grayed out / unavailable
    By bsassone in forum Excel General
    Replies: 0
    Last Post: 02-18-2006, 07:40 PM
  4. [SOLVED] Excel "Share Workbook" should not make some functions unavailable
    By Charlie in forum Excel General
    Replies: 0
    Last Post: 12-21-2005, 12:25 PM
  5. [SOLVED] "Urgent" use script to share the workbook
    By man in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 10:05 AM

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