Sharing of one single Excel file/workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm not all the new to Excel. However, I have a problem.

3 users in my team are sharing the same sheet in the same MS-Excel file. My
problem is this - when 2 users are working on the same cell/row, and when one
of them saves first, the second user loses his/her data saved in that
cell/row completely !! Ideally, I would have thought the system would take
the second person's data on to the next available free cell (in this case,
the next free row).

PLEASE HELP ?!

The conditions that I have set for this sharing is that, under 'Conflicting
changes between users', I have checked 'The changes being saved win'. Even
otherwise, it doesn't help.
 
Jk,
Don't know it this would help, but you might try the "Recording Change
Made to Worksheet " thread started by Paige

Kestre
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I save data in shared spreadsheet? 2
Shared Workbook User had unsaved information disappear 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Shared Workbook 3
Sharing workbook 3
LInking workbooks 8
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Sharing workbooks limitations - Merged Cells 12

Back
Top