I have been working on a call log workbook with Excel 2010 that has two sheets: Sheet 1 is a call log form that has 4 fields to document call information then a save button on the bottom to run a macro that copies the data and pastes it into sheet 2 to log the information. I have tried sharing this workbook on the local network and making sure that all users can edit, but this does not allow real time updates, and does not allow everyone to input data unless someone allows their data to save or the others data to save in which causes their data to be visible or the others.
I tried sharing this on OneDrive but since it is Excel 2010 it has to be opened via Excel on the desktop and not the web. I know that Access is the best route to take but my company doesn't want to pay for access for everyone in the office.
Is there a way to share a workbook in excel with multiple people and have it save all users inputs and update real time?
Is there anything in VBA that can be written to allow real time updates and to save all shared users changes without overwriting others changes?