+ Reply to Thread
Results 1 to 2 of 2

Sharing a worksheet and seeing changes made by others

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    Oshawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    29

    Sharing a worksheet and seeing changes made by others

    Hello All, three of us work on the same sheet to update it (2016).
    I would like to make it shared so we can make changes at the same time.
    The chance of us working on the same cell is low.
    I've created a bunch of hidden rows that we can unhide and fill out if needed to avoid the complications of inserting new ones.

    The issue: when my colleague unhides a row and inputs data, then saves, it does not reflect on my sheet after I save (or save, close and reopen). He does not re-hide the row yet I have to unhide rows to find his input.
    Is there a way to get around this issue?

    Thanks for any ideas.
    Last edited by Thom7890; 12-21-2018 at 11:08 AM.
    If anyone has helped - Add Reputation

  2. #2
    Registered User
    Join Date
    07-09-2013
    Location
    Oshawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Sharing a worksheet and seeing changes made by others

    Found the answer here at work - turns out the sheet saves on your personal last view. So if another user adds a row and enters data - you don't see it unless you unhide it.

+ 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. Block worksheet sharing
    By GCBragato in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2018, 10:24 PM
  2. [SOLVED] Auto duplicate changes made in one column of one worksheet to another worksheet
    By lektrikwiz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-13-2013, 12:23 PM
  3. Excel 2007 : Sharing Workbooks - "Book was made exclusive"
    By bjohnsonac in forum Excel General
    Replies: 3
    Last Post: 07-14-2010, 04:54 AM
  4. worksheet sharing
    By wingco in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-28-2009, 07:58 PM
  5. Sharing worksheet with query through ODBC
    By profector in forum Excel General
    Replies: 3
    Last Post: 05-28-2008, 07:49 PM
  6. [SOLVED] Sharing and protecting sections of a worksheet.
    By Ekazakoff in forum Excel General
    Replies: 1
    Last Post: 08-08-2006, 10:05 PM
  7. [SOLVED] Sharing Worksheet cannot complete task
    By Spirit130 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 09:05 AM

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