You are located in service: SharePoint Shared Services

Microsoft Excel (SharePoint)

Microsoft Excel (SharePoint)

 Detailinformation

In the following we would like to edit a CSV-file in MS Excel-format. To make changes to the file we click on the file-menu (hinted by the three parallel dots). Now we can choose the option "edit" among other settings to open a suitable program for editing. By default the MS Excel application of the Office 365 environment should open and present us with the possiblity of editing the file directly in our browser.

SharePoint Excel file properties

Instead of taking the detour over the file-menu we can also directly open the file in the MS Excel Web App. Thereto we just click on the filename. While doing so we need to consider however, that the file is only opened in a preview-view and we are only able to perform changes after a click on the option "edit document".

Excel edit document tool

Microsoft Office 365 Excel Web App editing-view:

Excel Web App editing-view

If we choose to open the file in the local version of Microsoft Excel, the window depicted in the following image opens.

Startup of local Excel application

By clicking on "open link", our local Excel Application (provided it is installed correctly) opens and we now have the opportunity to edit the document in a conventional manner.

Note that Excel, instead of saving the file on the local harddrive, does now update and synchronise the file directly in SharePoint. This means, that even when multiple people work on the same document, conflicts in the file-contents are prevented due to the central localization of the file.

last changed on 29.01.2021

How did this content help you?