First Time Start Up Of Microsoft Excel For Mac Asks For The Company Name And Email Id
Ever since Microsoft introduced live collaboration to its Office suite with the in September 2015, Excel has been left out in the cold. Word, PowerPoint and OneNote were given collaborative editing tools, but Excel was not. For nearly two years, Microsoft has been promising that Excel would get the capabilities as well. And now, finally, real-time collaboration is available in the desktop version of Excel — at least for those who have an Office 365 subscription and have updated to or later. Excel 2016 users who don’t have an Office 365 subscription (or users of older versions of Excel) can’t currently collaborate from within the desktop version of Excel, although they can still collaborate (or invite others to collaborate) using Excel Online in a browser. At some point, Microsoft says, the non-subscription desktop version of Excel will also get collaboration features, but the company isn’t saying exactly when. [ Further reading: ] For Office 365 subscribers who have updated to Version 1707 Build 8326.2058 or later, how do you collaborate in Excel, and how well does it work?
Read on for details. Sharing a spreadsheet A few notes before getting started: First, you can collaborate only with files stored in OneDrive, OneDrive for Business, or SharePoint Online, so make sure any files you want to share are stored there and that you’re logged into your Office 365 account. Second, real-time collaboration works in Excel only if you have AutoSave turned on. To do it, choose the “On” option on the AutoSave slider on the top left of the screen. (This slider shows up in version 1707 Build 8326.2058 or later, but no versions before that. It’s a convenient way to tell whether you’ve got a version of Excel that allows for live collaboration.) [ To comment on this story, visit. ] [ ] With that done, let’s get started.
If you’ve ever collaborated on documents or presentations using the Office 2016 versions of Word or PowerPoint, you’ll be familiar with how to do it in Excel. When you want to collaborate with others on a workbook, first open it, then click the Share button on the upper-right of the Excel screen. What happens next depends on whether your document is stored in your own OneDrive or with OneDrive for Business or SharePoint Online. If your files are stored in your personal OneDrive, you’ll share spreadsheets via the Share pane. But if your files are stored in OneDrive for Business or SharePoint Online, you’ll use a newer interface that Microsoft rolled out to enterprise Office 365 users in May 2017.
A Microsoft representative told us that the company intends to roll out the newer interface to consumers with an Office 365 subscription at some point, but it hasn’t announced timing yet. So we’ll give instructions for both interfaces below. If your document is stored in your personal OneDrive: When you click the Share button, the Share pane opens on the right side of the screen. Enter the email address of the person with whom you want to share in the “Invite people” text box.
Enter multiple addresses, separated by commas, if you want to share the document with multiple people. One feature I found particularly useful when adding email addresses: As you type, Excel looks through your address book and lists the names and addresses of contacts who match the text you’ve input. Click the address you want to add. This not only saves you a bit of time, but helps make sure you don’t incorrectly type in addresses. If you’re on a corporate network, you can instead click the address book icon to the right of the box and choose the person or people you want to share with from there.
Preston Gralla / IDG Inviting someone to collaborate on a workbook via the Share pane. (Click image to enlarge.) Next, choose what kind of collaboration rights you want to give the people you invite by clicking the down arrow in the box underneath “Invite people.” You’ve only got two choices — “Can edit,” which means they have full editing rights, or “Can view,” which means they can only view the spreadsheet as you work on it and not make any changes.
Sky q app for macbook. If you want to give certain people editing privileges and others view-only privileges, you can send two separate invitations with different rights selected. Finally, if you want to send a message to the people you’re inviting, type it in the “Include a message” box. When you’re all done, click the Share button. Once you do that, an email is sent to your recipients with a link to the spreadsheet, and their names show up in the Share pane, just beneath yours. Preston Gralla / IDG Your collaborators will get an email like this when you share a spreadsheet.