Clicking this will open a new window in which you can select the program you want, either from the default list or by browsing (click “Browse”). > When you have selected the program you want (e.g. VLC), and you are sure you would like all videos of that format to open with said program, tick the box at the bottom that says “always open.
If an author has to protect it from being modified by others but now you want to remove the read-only mode, read this page to learn based on the three cases. Case 1: If the Excel 2016 workbook is just marked as final to let readers to know it is final and read-only, to disable the read-only mode, just need to open the Excel 2016 workbook and then click the Edit Anyway button on the yellow warning appeared at the top of the workbook. Case 2: If a password to modify is added to, anyone who doesn’t know the true password only can open this workbook in read-only mode and changes he makes can’t be saved unless he save the workbook with a new name or in a different location. In this case, to disable read-only, do as follows. Step 1: Open the Excel 2016 workbook. Type the password for write access and click OK.
Step 2: Click File - Save As, select one location where you will save this document. Step 3: In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options. Step 4: In the General Options dialog, delete the password to modify and uncheck the box next to Read-only recommended, and then click OK. Step 5: When you are back to the Save As dialog, click Save to save the workbook.
![Windows Windows](http://cdn.osxdaily.com/wp-content/uploads/2018/05/disable-close-windows-when-quitting-app-mac.jpg)
Then the read-only mode in the Excel 2016 workbook can be disabled. Case 3: The author of an Excel 2016 workbook may protect the sheet and lock the cells so that users only can open and read the workbook but can’t be able to make changes to it. Once the reader attempts to change the worksheet, he will be prompted with the warning message shown below. In this case, to disable read-only, you need to unprotect the sheet by the following steps. Step 1: Open the Excel 2016 workbook. Step 2: Select the Review tab and click Unprotect Sheet. Step 3: If asked for the password, type it and click OK.
Tips: If the password has been forgotten or lost, then you need to use VBA codes or 7-zip to 2016 and disable the read-only.
![How To Stop Auto Open Windows In Excel For The Mac How To Stop Auto Open Windows In Excel For The Mac](http://www.howtogeek.com/wp-content/uploads/2015/05/650x314x26_clicking_the_file_tab.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.O2uNTquiKm.png)
Microsoft encourages users to save their work in OneDrive by making it the default save location in Office 2013. This is handy if you regularly use OneDrive to backup and sync your files, but for those who use online services, or those who prefer to save their files locally, it’s annoying and inefficient to have to deselect OneDrive each time you try to save a file, and instead manually navigate to your save location of choice. Thankfully, this problem can be easily solved by setting a new default save location in Office 2013 settings.
Note that the steps described here are unique to each major Office app, so you’ll need to repeat these steps in Word, Excel, and PowerPoint if you want all three apps to save to the same new default location. However, by maintaining separate settings for each app, it makes it easy to set different default save locations depending on your workflow; for example, saving all Word documents to your local user documents folder, and saving all Excel files to a network location shared with the Accounting department. For our screenshots, we’re using Word 2013, but the steps are the same for Excel and PowerPoint. First, launch your Office 2013 app and open an existing document, or create a new document.
With the document open and viewable, find and click File in the top-left portion of the window. This will launch what Microsoft calls the Office ““, which lets you open existing documents, create new documents, and access important feature such as print and export settings. Locate the Options button at the bottom of the list on the left. In the Options window, select Save from the list of options on the left. This reveals a number of save-related settings and preferences. To remove OneDrive as the default save location, find and check the box labeled Save to Computer by Default.
This will tell Word, Excel, or PowerPoint that you want your documents to be saved to your computer, or a network-attached volume, instead of an online service like OneDrive. The default save location is your user Documents folder. If the user Documents folder works for you, then you’re all set. If, however, you’d prefer to set a custom save location, click the Browse button next to the Default Local File Location box and navigate to the desired location on your PC.
When you’ve made your selection, click OK to save it, and OK again to close the Options window. You’ll now need to quit and restart Word, Excel, or PowerPoint in order for the change to take effect, so manually save any open documents and close your Office apps. After reopening Word, Excel, or PowerPoint, any new save commands will select the location on your PC that you identified in the Options window by default. Of course, you can still save to OneDrive or any other location on your PC, but you’ll need to manually navigate to these locations in the Office Save window. Therefore, to maximize efficiency, make sure you set your most-used save location in Office 2013 settings, ensuring that, most of the time, all you have to do is click “Save” to place your document in its intended location. Want news and tips from TekRevue delivered directly to your inbox?
Sign up for the TekRevue Weekly Digest using the box below. Get tips, reviews, news, and giveaways reserved exclusively for subscribers.