Home » Spreadsheet Software » How To Share an Excel Spreadsheet
How To Share an Excel Spreadsheet

How To Share an Excel Spreadsheet

How To Share an Excel Spreadsheet – Sharing an Excel spreadsheet in red is one of the questions most users have asked a long story in the spreadsheet.

If a user needs to open an Excel document that was already opened by another user, he / she will encounter a dialog that only allows to open the document to consult or request the use that communicated the moment in which Another user closed the document.
But this drawback is easy, since an Excel spreadsheet document in red is very simple.

In the 2007 and 2010 versions you only need to activate from the Review tab the Share book option.

Excel workbooks can be shared unless they contain tables or XML mappings. In either case, the application displays a message that indicates the appropriate steps to convert a table to a range from the Layout tab of the Table tool group, or to remove XML sources from the Scheduler tab.

How to share an Excel spreadsheet in network

If the book does not contain these elements will present a dialogue from which we can easily activate the sharing of the book, simply by activating the option marked in the image with the red arrow and clicking OK.

How to share an Excel spreadsheet in network

From this same option, by activating the Advanced Usage tab we can define the behavior of the change control, the automatic update time of the book and the behavior against conflicting changes between users (two users make changes on at least one same cell or object).

How to share an Excel spreadsheet in network

Once you click the OK button, Excel prompts you to save the workbook to enable sharing.

How to share an Excel spreadsheet in network

If you want to stop sharing the book, you only need to deactivate the option marked with the red arrow and that previously activated.

How To Share an Excel Spreadsheet