Multiple users updating one excel spreadsheet
Problems can occur when users attempt to share workbooks using the public folder, a workgroup or a server.
You can also drag to select the desired cells to merge in the wizard to reference the cells by position only, regardless of category name or data type. Open Excel, and then open the first of the spreadsheets to be merged.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.Click the file, and then click “OK.” The file path is added to cell references for the merge.Click the “Left Column" option if categories are listed down the left side of the spreadsheet.