Open the workbooks you wish to combine. Select the worksheets in the source workbook that you want to copy to the main office.com/setup select multiple sheets, use one of the following techniques. To select adjacent sheets, click on the first sheet tab that you want to copy, press and hold the Shift key, and then click on the last sheet tab. This will select all worksheets in select non-adjacent sheets, hold the Ctrl key and click on each sheet tab individually. With all worksheets selected, right click on any of the selected tabs, and then click Move or Copy In the Move or Copy dialog box, do the following. From the Move selected sheets to book drop-down list, select the target workbook into which you want to merge other files. Specify where exactly the copied sheet tabs should be inserted. In our case, we choose the move to endoption. Select the Create a copy box if you want the original worksheets to remain in the source file. Click OK to finish the merge process. Read More
If you can't work with a SharePoint file type then you need to change the type to Microsoft Excel or OneNote before you save the file. Excel will allow you to open and edit the Excel spreadsheet. OneNote will allow you to annotate the .ODT files. With a Microsoft Office or OneNote file opened in Excel or OneNote you can then change or add to the data in the document. If you'd like to use Microsoft Excel instead just change the file type to Microsoft Excel (or OneNote) before you save it. In any scenario in which your document doesn't contain embedded graphics or PDF files you'll need to open it in OneNote. This is not possible in the view mode. You can share Excel documents by right-clicking on the file and selecting “Share the link”. By default, this will open the file in Microsoft PowerPoint with a blank page. If you'd like.