Open File Options in Microsoft Office 2013

When we want to open a file in one of the Microsoft Office applications such as Microsoft Word, PowerPoint and Excel we have a variety of options on how to open the specific file.  These options will be described below and the application that I used for this post is Microsoft Excel 13. In this post are featured the common commands between Microsoft Office applications.

If we select the drop down button which is located at the bottom right corner of the Open dialog box and next to the command Open we can do one of the following:

  • Open
  • Open Read Only
  • Open As Copy
  • Open In Browser
  • Open In Protected View
  • Open And Repair

All the above commands let us open the files in a different way which I will describe below:

Open

This is the most ordinary way we Open files in order to edit them.

Open

 

Open Read Only

When using this command we can only look at the file, which means we can edit it, but we can’t save the changes that we have made to the actual file. In order to save it, we must use the Save As command and give the file a new name.

Open Read-Only

In the image below is an example of using the command Open ReadOnly, where we notice the [Read-Only] at the right of the workbooks file name.

Read Only

 

Open As Copy

When using this command, it opens a copy of the file that we have selected. This is a quite handy feature in case we don’t want to mess up with the original file. We can always have the original file as a backup copy.

Open As Copy

In the image below is an example of using the command Open As Copy, where we notice the Copy (1) at the left of the workbooks file name. We can open as many copies as we want, but each time the number will change depending on how many copies we have opened.

Copy

 

Open In Browser

When we use this command, it opens the file that we have previously saved as a Web Page with our default browser. If we have saved the file as an ordinary file, the command will not be available to use.

Open In Browser

Once the Open In Browser command is selected, a security dialog box appears, warning us about potential security concerns as shown in the image below. If we want to continue we just press the Yes button or the No button if we don’t want to open it.

Security Warning

In the image below is an example of the file opened with our default Web Browser.

Web Browser

 

Open in Protected View

When we select this command, the file opens in Protected View, meaning that we can’t not make any changes to the contents, unless we click the Enable Editing button.

Open In Protected View

The image below is an example of using the command Open In Protected View, where we notice [Protected View] at the right of the workbooks file name, and the Protected View ribbon right below with the warning Protected View: This File Was Opened In Protected View, and the Enable Editing button, which we can press in order to activate the workbook for editing.

Protected View

 

Open and Repair

We use this command, when we have a corrupted file. This command tries to repair the file before it opens.

Open And Repair

Once we select the Open And Repair button a Microsoft Excel Warning dialog box appears as shown below which we can do one of the following:

  • Repair: We select this command if we want to recover as much of our work as possible.
  • Extract Data: We select this command if we want to extract as much data as we can, just in case the Repair command did not work.
  • Cancel: If we want to cancel Opening and Repairing the workbook.

Repair

Below you can check out the video describing the different options on how to open a file in Microsoft Office 13.

Open File Options in Office 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on January 7, 2014, in Microsoft Office 2013 English, Office 2013 English and tagged , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Open File Options in Microsoft Office 2013.

Comments are closed.