how to work with multiple users on an excel worksheet

The field Who has this workbook open now: will display any user(s) with an open instance of the workbook.On the Editing tab, select the option to Allow changes by more than one user at the same time.Click the Review tab, select the Share Workbook option from the Changes Group.(Steps below apply to Excel versions 2007-2016) Excel will prompt the user that the workbook is already in use by another user.) Set up workbook for sharing Unless the spreadsheet user activates sharing, multiple users attempt to open the same workbook on a shared drive at the same time will receive an error message. (Note that, by default, workbooks are not shared. To share or not to Share: Excel documentsĮvery version of Microsoft Office Excel has included an option to share a workbook that allows multiple users to open the workbook and edit its data.

A recent question fielded to me was about a client needing options for sharing a workbook in Excel that would allow multiple users on her executive team to input data simultaneously. Occasionally, though, an RSE will pull me aside to ask about an issue he or she hasn’t encountered before.

Whether onsite at the client’s office or by phone or messaging from our remote help desk, RSEs field a wide array of questions about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, and the rest of the Office suite. Generally, our Remote Systems Engineers (RSEs) get to be the heroes. Most of these clients have staff using Microsoft Office applications-and most Office users, sooner or later, have had some odd experiences within these applications. I work with dozens of highly certified and skilled engineers who interact frequently with the businesses contracting our company for managed I.T.

How to work with multiple users on an excel worksheet