Saving issue

Harshavardhan Reddy 1 Reputation point
2020-07-14T12:36:11.927+00:00

Hi,

I want to edit the excel file simultaneously(2 or more members) from file server .

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2020-07-14T12:56:23.52+00:00
    0 comments
  2. Bukeka Mosala 1 Reputation point
    2020-07-14T13:02:25.317+00:00

    hi
    try this method 

    Click the Review tab.
Click Share Workbook in the Changes group.
On the Editing tab, click to select the Allow changes by more than one user at the same time. ...
In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.
    0 comments
  3. Emily Hua-MSFT 27,526 Reputation points
    2020-07-15T07:10:15.873+00:00

    As DSPatrick and BukekaMosala-3904 replied, enabling the Shared Workbook feature could meet your needs.

    In this case, multiple users could edit the shared file simultaneously. When other users edit and save the workbook, each person's copy of the workbook will update, and Excel is charged with resolving potential conflicts in data.

    But Shared Workbooks have limitations, more detailed information, please checkout the article "About the shared workbook feature"

    0 comments