If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.
The Consolidate Data wizard enables you to merge data by cell position or by category name.
Click the Advanced tab, and modify those settings as desired. If two users are editing the workbook at the same time and User A saves the workbook, User B will receive a "Your workbook has been updated with changes made by others" message when attempting to save the workbook.
To merge by position and not category, leave the “Top Row” and Left Column” check boxes empty. Click the first cell in the first spreadsheet to be merged, and then drag the cursor over all cells to merge.Unlike previous versions of Windows, the public folder is part of the Home Group feature in Windows 8.1.All users who need to access the workbook must join the homegroup. To do so, click Share Workbook in the Changes group on the Review tab, and select the "Allow changes by more than one user at the same time" checkbox.Click the button once again to restore the dialog box. Repeat opening each spreadsheet, and then selecting the data to merge.Click the “Add” button in the Consolidate Data wizard to add the references.One alternative is to use Excel Online in One Drive.Multiple users can edit the same worksheet, and you can see which cells other users are editing in near real time.Problems can occur when users attempt to share workbooks using the public folder, a workgroup or a server.In addition, sharing a workbook does not work with conditional formatting, charts, pivot table reports and several other Excel features.How can I set up public folders so that more than one person can save changes to an Excel spreadsheet at a time?Although it's possible to share an Excel workbook with multiple users and allow them to work on the file simultaneously, many users have reported problems with file corruption, overwritten data within worksheets and even worksheets that have lost all data.