Multiple users updating one excel spreadsheet
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.
Excel Online makes it easy for you to: To use Excel Online on One Drive, you need a Microsoft account.
Use that ID to sign in and then go to One Drive to access Excel Online.
No more sending a workbook around via e-mail, or waiting for someone else to check it back in on the server.
I have one Master excel file called "00" containing 3 sheets "00", "01", "02". I need to have 2 separate excel files called "01" and "02" that connect to "01" and "02" sheets in master file "00".
It's really all about providing easy access to your data via a browser—to anyone, anywhere, at anytime.
No need for other people to have Excel installed to view, edit, or collaborate on that data.
Ideally, you should keep the consolidation process simple by opening all spreadsheets to be merged in the same workbook. Click the “Function” drop-down box, and then click “Sum” if you just want to replicate the original data in the master sheet.This is why having all spreadsheets open in a single workbook simplifies the process.If all spreadsheets are located in the same workbook, the file path is not necessary in the References field. Click the “Top Row” check box to merge by categories listed along the top row.Many Excel features are available in Excel Online, but not all features are supported or work exactly the same way.To make changes beyond what you can do in the browser, Excel Online includes a way for you to open the workbook in Excel, and then save it back to the server.
You can also click another function to perform a calculation on the data as the sheets are merged. Click the “Browse” button and navigate to the workbook containing the first spreadsheet to merge -- this is necessary only if the spreadsheet is in a different workbook.