Microsoft Excel Workbook

February 20, 2020 - by Bill Jelen

Prior to Excel 2007, the default file extension was XLS. The main difference between the two is that XLSX is an XML-based open file format and XLS is a proprietary Microsoft format. But, the newer versions of Excel save and open XLS files for the sake of compatibility with earlier versions of the program. Click Recover Unsaved Documents if you are in Word, Recover Unsaved Workbooks if you are in Excel or Recover Unsaved Presentations if you are in PowerPoint. You will see the list of your unsaved files. Select the file and click Open. In the business bar at the top of the file, click Save As to save your file to your computer.

For decades, some people have been wanting a better way to have multiple people in the same workbook at the same time. The old Shared Workbook functionality was awkward. People resorted to only one person having write access at a time', which led to someone opening the file and then forgetting to close it before going for a two-hour lunch and tying up the file that whole time.

After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017.

The feature works well once you get it set up. But it is difficult to figure out all of the steps to allow multiple people to use Excel on their computers instead of having some people stuck using Excel online.

To start, choose one person to be the owner of the workbook. This person should already have a One Drive For Business or SharePoint Online folder set up. The owner of the document should use File, Save As and choose to save the document in either OneDrive or SharePoint Online.

The owner of the workbook clicks the Share icon in the top right corner of Excel.

The Share panel asks you to invite people by e-mail address.

But if you look at the bottom of the panel, you can generate a sharing link.

Generate a sharing link where anyone with the link can edit the workbook.

Copy the link and send it to others on your team.

The next step is the annoying part. When they follow the link, they will be taken as a guest to Excel Online. The spreadsheet will appear and they can edit in Excel Online. I talked to people from one company who stopped at this point. One person (the workbook owner) would edit in Excel and everyone else was stuck in Excel Online.

Caution

As shown below, the 'Edit in Browser' button is very prominent and it is what you are likely to click. In desperation, you might try clicking Download, but this removes the ability to co-author. Not so obvious in the top right corner is the Sign In button.

How To Use Excel Spreadsheet

For the other co-authors to use the workbook in the real version of Excel running on a PC, they have to first Sign In to Excel online. Use the credentials that are shown in Excel under File, Account.

Once they have signed in, then the Edit Workbook drop-down menu appears. Open the menu and choose Edit in Excel. This is the only way to have everyone co-author and use the real desktop Excel instead of Excel Online.

While you and others are working in a document, your active cell will be outlined in green. The active cells for others will be other colors. If you want to know who is editing a cell, hover over that cell.

Co-authoring will work fine provided everyone avoids editing the same cell at the same time.

When someone (probably your manager), dives in to edit a cell that you are already editing, then a confusing set of rules decides who's edit wins. Rather than dealing with these rules, be happy that co-authoring mostly works and have everyone agree not to edit the same cell at the same time.

Co-authoring is a whole new experience. There are good things and bad things that you need to get used to when you are co-authoring.

Title Photo: Perry Grone at Unsplash.com

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

-->

Microsoft Excel Sheet

Represents a Microsoft Excel workbook.

Remarks

The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.

The ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is running. In most cases, this is the same as the active workbook. However, if the Visual Basic code is part of an add-in, the ThisWorkbook property won't return the active workbook. In this case, the active workbook is the workbook calling the add-in, whereas the ThisWorkbook property returns the add-in workbook.

If you are creating an add-in from your Visual Basic code, you should use the ThisWorkbook property to qualify any statement that must be run on the workbook that you compile into the add-in.

Example

Use Workbooks (index), where index is the workbook name or index number, to return a single Workbook object. The following example activates workbook one.

The index number denotes the order in which the workbooks were opened or created. Workbooks(1) is the first workbook created, and Workbooks(Workbooks.Count) is the last one created. Activating a workbook doesn't change its index number. All workbooks are included in the index count, even if they are hidden.

The Name property returns the workbook name. You cannot set the name by using this property; if you need to change the name, use the SaveAs method to save the workbook under a different name.

The following example activates Sheet1 in the workbook named Cogs.xls (the workbook must already be open in Microsoft Excel).

The ActiveWorkbook property of the Application object returns the workbook that's currently active. The following example sets the name of the author for the active workbook.

This example emails a worksheet tab from the active workbook by using a specified email address and subject. To run this code, the active worksheet must contain the email address in cell A1, the subject in cell B1, and the name of the worksheet to send in cell C1.

Loadingjewelry973