+ Reply to Thread
Results 1 to 3 of 3

Setting up excel for online viewing/editing by multiple users

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Pensacola, Fl
    MS-Off Ver
    Excel 2021
    Posts
    36

    Setting up excel for online viewing/editing by multiple users

    What I have is a football selection workbook. 1 sheet represents one week of games for that week. I have close to 100 players and currently enter the data using the copy/paste special function when the players make their selections in an online message board forum. What I would like to do is allow users to enter their own game picks but restrict their access to view the games we are picking from and their username column to enter their picks on their own. I'm think I'll have to assign passwords to all users to make this happen, but after doing some research online, I can't figure out if this is even possible or how to make it happen. Any ideas will help.

    Check out my sample below. I want all users to see the Range of B4-23 and C4-C23 and E4-E23. Then I want the specific user to have access to his cell range to enter their own selections but NOT be able to edit anything other than their own column range, For example, the first player: 19au48, I want him to only be able to edit the cell range of G4-G23. The users selection cells are the same every week, but there are different sheets in the workbook for each week of the season.

    Is what I'm wanting to do here even possible and if so how complicated is it to set up?
    Attached Images Attached Images

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Setting up excel for online viewing/editing by multiple users

    A couple of questions, for clarification purposes.

    Will all 100 players have access to the same file? By this I mean one file on one computer/network?
    If so, how do you plan on dealing with file access conflicts?

    BSB

  3. #3
    Registered User
    Join Date
    08-29-2012
    Location
    Pensacola, Fl
    MS-Off Ver
    Excel 2021
    Posts
    36

    Re: Setting up excel for online viewing/editing by multiple users

    Well, that poses another issue that I hadn't considered. Obviously I would need the ability to have more than 1 person have access to the sheet at one time.
    This may not be doable. Multiple people accessing the sheet is not something I considered.

+ 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 editing workbook at same time
    By amymsellers in forum Excel General
    Replies: 2
    Last Post: 06-07-2016, 08:39 AM
  2. Replies: 0
    Last Post: 06-25-2015, 07:15 AM
  3. Replies: 1
    Last Post: 06-03-2014, 03:24 PM
  4. Replies: 5
    Last Post: 05-22-2012, 04:14 PM
  5. Excel Spreadsheet Refresh for multiple viewing users
    By Surge89 in forum Excel General
    Replies: 1
    Last Post: 10-18-2011, 03:01 PM
  6. Replies: 9
    Last Post: 10-15-2010, 08:40 AM
  7. [SOLVED] Can I use Excel, opening and editing files, online?
    By AlisonHunter in forum Excel General
    Replies: 0
    Last Post: 06-01-2006, 06:45 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