Right-click Logins, and then click New Login. In SQL Server Management Studio, connect to the database engine. To create a SQL Server logon for the data access account If you are using a data source other than SQL Server, see the instructions for your data source to create a logon with data read permissions for the data access account.)įollow these steps to create a SQL Server logon and grant Read access to the database. (in this article, we use the example of accessing a SQL Server database through an Active Directory account. This account will be stored in Secure Store.Īfter you have created the account, the next step is to grant that account read access to the required data.
This can be an Active Directory account, a SQL Server logon, or other set of credentials as required by your data source. You must have an account that can be granted access to the data source to which you want to connect your Excel workbook. Using Excel Online with an ODC file consists of the following steps:Ĭonfigure an Excel workbook to use the published ODC file as a data connection To use an ODC file, you must also configure server-to-server authentication between Office Online Server and SharePoint Server. This allows you to share a single ODC file among multiple workbooks and also allows you to centrally manage your data connections.īefore you can use Excel Online with an ODC file, you must have installed Office Online Server and configured it to work with SharePoint Server.
#How to use microsoft excel online how to#
This article describes how to do this.īy using an ODC file for your data connection, you separate your Excel workbooks from the data connection information. You can use an Office Data Connection (ODC) file that specifies a Secure Store target application. (This is known as an embedded connection.) For more information, see Configure Excel Online data refresh by using embedded data connections in Office Online Server.
You can specify a Secure Store target application in a workbook. Learn more about printing gridlines in a worksheet.Summary: Configure Excel Online data refresh by using Secure Store and an external Office Data Connection (ODC) file.Įxcel Online provides two methods of using Secure Store Service to refresh the external data source in a workbook: If the final print preview looks right, click Print. If you change your mind about printing a selected area, choose the Entire Sheet print option and click Print. To print the whole worksheet, don’t select anything before going to the Print command. Select the cells or chart you want to print, and then go to File > Print. See Collaborate on Excel workbooks at the same time with co-authoring for more information. Other versions of the Excel app also allow working with others at the same time. This only works when everyone is working in Excel for the web. When others edit the worksheet, Excel for the web shows their presence and the updates right away. When you’re working with others in Excel for the web, you can edit the worksheet as you usually would. Here's how you can switch to editing view:Ĭlick Edit Workbook > Edit in Excel for the web.įor more advanced editing options, click Edit in Excel.Įxcel for the web saves your work automatically however, if you change your mind about any changes you’ve just made, use Undo or press Ctrl+Z. If you try to enter data, set up a formula, add charts, or apply basic formatting and nothing happens, you’re probably in read-only view. To share a workbook, click Share and type email addresses of people you want to share with or get a link you can email to your contacts. People can view your worksheets, sort and filter data, and drill into the details of PivotTables on the web or mobile device. To rename the workbook, select the generic name of the new file on the top ribbon (generally something like Book1). In the File Name box, type a new name.Īfter you’ve created your online workbook, you can share it with friends, coworkers, or the public. Open your OneDrive by selecting the OneDrive icon on your system tray and then selecting View online. If your organization or college has a Microsoft 365 plan or SharePoint site, start using Excel for the web by creating or storing workbooks in libraries on your site.
With Excel for the web you use your web browser to create, view, and edit workbooks you store on OneDrive or Dropbox.