how to make excel file shared office 365

Or, if this is an existing workbook, click OK to save the workbook.Are you still using an on-prem File Share to host all of our company data? If this is a new workbook, type a name in the Save As box. If you prefer those locations for the file, co-author the workbook instead. Don't put the file on OneDrive or SharePoint. Shared Workbooks have limitations, and therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.Ĭreate a new workbook or open an existing workbook.

Using the XML Source task pane, XML toolbar, or XML commands on the Data menuīe certain that you want to use this method before continuing. Writing, recording, changing, viewing, or assigning macrosĪdding or changing Microsoft Excel 4 dialog sheets Protecting or unprotecting worksheets or the workbook Inserting or changing pictures or other objectsĪssigning, changing, or removing passwords The table below is only a partial list of features not supported.Ĭreating or changing charts or PivotChart reports Therefore, many items and actions are not supported when this method is used. Please be aware that Shared Workbooks is an older method of sharing. When you're done, - Shared will appear at the top of the Excel window, next to the filename. If the workbook contains links to other workbooks or documents, verify the links and update any links that are broken.

Or, if this is an existing workbook, click OK to save the workbook. If this is a new workbook, type a name in the File name box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK. On the Editing tab, select the Allow changes by more than one user. Note that in newer versions of Excel, the Share Workbook button has been hidden.

For example, put it on a location like \server_nameolder_name. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.Ĭreate a new workbook or open an existing workbook. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web. Be certain that you want to use this method before continuing.

How to make excel file shared office 365