Advice needed on multiple users using a excel workbook

[ghrek]

Hi

I have a excel workbook that I want multiple users to be able to input data at the same time.

I know how to set up Share Workbook (Legacy) command in excel 2016 and that works good and ive been playing around with it using 2 different excel users.

The issue I think I have is when one user copies and pastes a lot of data into a workbook when the cells are still blank and someone in another workbook also tries to input data at the same time again in the same blank cells on a different user account what happens? I need all the data added and not overwritten.



Any Ideas?

 

[mole999]

part of the share process should enable you to ensure that updates are seen by other users with a refresh > Shared Workbook Limitations