At the file level, you can password protect an Excel workbook in two ways: You can. Tutorial, which was first published in January 2011 and updated in March 2019. I'm using Office 365 Excel (desktop), but you can user earlier versions. This user just can't save the changes to the protected workbook.
![](/uploads/1/2/6/6/126619550/803551652.jpg)
Important: Even if you have AutoRecover enabled, you should save a file frequently while you are working on it to avoid losing data due to an unexpected power failure or some other problem. AutoRecover is described later in the topic 'Save AutoRecover information automatically.' When you save a file, you can usually change its name, storage location, and file format all at the same time, if you want to do so. However, you might not want to do all of those things, and the instructions in this topic describe each option individually. Office allows you to save files in online folders provided by OneDrive and SharePoint. If you have accounts that give you access to these services, you can save and access files stored on these services much like files stored on your computer.SharePoint services and OneDrive for Business are typically offered by an employer or organization, but you can use OneDrive on your own. For more information about these services, see the related topics in.To save a file to an online location other than the default folder, use Save as.
![Unable To Save Changes To Excel Spreadsheet In Office 2011 For Mac Unable To Save Changes To Excel Spreadsheet In Office 2011 For Mac](/uploads/1/2/6/6/126619550/990560091.png)
You can save files from Word, Excel, or PowerPoint directly to folders on OneDrive and SharePoint services.On the File menu, click Save as, or press+ Shift + S.If the dialog box shows a folder on your computer rather than on an online service, click Online Locations.If you see the On My Mac button, the dialog box is currently displaying an online location.Navigate to the folder where you want to save your file.You might need to click the name of a service on the left before you can access the folder you want. If you do not see the service that you need to access, click the plus sign to add a service.If you want to create a new folder in the folder that you are currently viewing, click New Folder, and then enter a name for the folder.In the Save As box, enter a different file name if you want.Click Save. If you need to share a file with someone who does not have Office for Mac or who has an older version, you can save your document in a file format that a different or older application can read. You can also export a document as a PDF file or an HTML file, among other choices.On the File menu, click Save As.If you want to change the file name, change the name in the Save As box.In the File Format list, click the file format that you want to use.For example, click Word 97-2004 document (.doc) to create a file that is compatible with Word 97 and later versions of Word that do not use the XML-based file format (.docx).Click Save. AutoRecover can help you recover a file that you were editing after a power failure or other problem that interrupts you while you are editing the file.
The more frequently that AutoRecover saves files information, the more complete recovery can be after a failure.However, using AutoRecover does not replace saving your files at regular intervals or when you are done editing the file. You may also find it helpful to save multiple versions of a file to different file names (for example, after each significant change) so that you can review or return to an earlier version, if necessary.If after a failure, you choose not to save the recovered version of a file after you open it, the file is deleted, and your unsaved changes are lost. If you save the recovery file, it replaces the original file, unless you specify a new file name.On the Word, PowerPoint, or Excel menu, click Preferences.Under Output and Sharing, click Save.Select Save AutoRecover info.In the Save every box, enter the number of minutes you want as the interval between saving AutoRecover information.Each time that the application saves AutoRecover information, it waits for the number of minutes that you specify here to pass before saving AutoRecover information again. Office allows you to save files in online folders provided by OneDrive and SharePoint. If you have accounts that give you access to these services, you can save and access files stored on these services much like files stored on your computer.SharePoint services and OneDrive for Business are typically offered by an employer or organization, but you can use OneDrive on your own.
![How to save excel file on mac How to save excel file on mac](/uploads/1/2/6/6/126619550/198251432.png)
For more information about these services, see the.To save a file to an online location other than the default folder, use Share. You can save files from Word, Excel, or PowerPoint directly to folders on OneDrive and SharePoint services. Note: If you're having trouble saving to an online location, make sure you're connected to the Internet and that you are signed in to either SharePoint or OneDrive. When you create and save a workbook, Word, Excel, and PowerPoint automatically save the file in the Open XML format. However, you can save the file in another format or change the default file format.Save a file in the Open XML Format (the default file format for Office for Mac 2011).Create a file, or open the file that you want to save.On the File menu, click Save As.In the Save As box, type a name for the file.On the Format pop-up menu, make sure Word Document (.docx), PowerPoint Presentation (.pptx), or Excel Workbook (.xlsx) is selected, depending on the Office program you're using.Click Save.Save a file in the Office 2004 for Mac file format.
Important: Some items that were created by using features in Office for Mac 2011 might behave differently when the document is saved in the file format that is used by Office 2004 for Mac or earlier. Use the Compatibility Report to avoid using new Office features that might behave differently with earlier versions of Office.Create a file, or open the file that you want to save.On the File menu, click Save As.In the Save As box, type a name for the file.On the Format pop-up menu, click Word 97-2004 Document (.doc), PowerPoint 97-2004 Presentation (.ppt), or Excel 97-2004 Workbook (.xls), depending on the Office program you're using. Note: PDF files created from Office 2011 are limited to printable content. In other words, if the content does not appear in print, it will not appear in the PDF.Create a file, or open the file that you want to save.On the File menu, click Save As.In the Save As box, type a name for the file.On the Format pop-up menu, click PDF.Click Save.Change the default file format that files are saved inYou can change the file format that Office for Mac always saves documents in. Note: We recommend that you preview the file in a web browser to make sure that the results are what you want. To do this, on the File menu, click Web Page Preview.Create a file, or open the file that you want to save.On the File menu, click Save as Web Page.In the Save As box, type a name for the file.Click Save.Save a file as plain text (Word only)You can save a document as plain text so that the document can be opened by a number of text editing programs. However, saving a document in plain text does not reliably preserve the formatting, layout, or other features of the document.Create a file, or open the file that you want to save.On the File menu, click Save As.In the Save As box, type a name for the file.On the Format pop-up menu, click Plain Text (.txt).Click Save.Save a file as JPEG (PowerPoint only)When you save a presentation as a JPEG, each slide becomes a picture.
Then, if you post the presentation on a Web site, the presentation is easier to view.Create a file, or open the file that you want to save.On the File menu, click Save as Pictures.In the Save As box, type a name for the file.Click Save.Save a file as a movie (PowerPoint only)To run your presentation on a computer that doesn't have PowerPoint installed, you can save your presentation as a movie (.mov) file. You can then play the movie in any application that supports QuickTime movies.Create a file, or open the file that you want to save.On the File menu, click Save as Movie.In the Save As box, type a name for the file.Click Save.
AutoRecover can help you recover a file that you were editing after a power failure or other problem that interrupts you while you are editing the file. The more frequently that AutoRecover saves files information, the more complete recovery can be after a failure.However, using AutoRecover does not replace saving your files at regular intervals or when you are done editing the file.
You may also find it helpful to save multiple versions of a file to different file names (for example, after each significant change) so that you can review or return to an earlier version, if necessary.If after a failure, you choose not to save the recovered version of a file after you open it, the file is deleted, and your unsaved changes are lost. If you save the recovery file, it replaces the original file, unless you specify a new file name.On the Word, PowerPoint, or Excel menu, click Preferences.Click Save.In the AutoRecover box, enter the number of minutes you want as the interval between saving AutoRecover information.Each time that the application saves AutoRecover information, it waits for the number of minutes that you specify here to pass before saving AutoRecover information again. When you open a document in Word for Mac 2011 that was created in an earlier version of Word, either Word for Mac or Word for Windows, compatibility mode is turned on. Compatibility Mode shows in the title bar of the document window. Compatibility mode indicates that the document was created in an earlier version of Word or was saved in an earlier file format. In compatibility mode, no new or improved features in Word 2011 are available.
However, users can still edit the document by using features that are compatible with the earlier file format.You can work in compatibility mode or you can convert your document to the Word 2011 file format. When you save in the Word 2011 format, the document layout appears as if it were created in Word 2011 and the file format changes from.doc to.docx. In this format, you can access the new and improved features in Word 2011.
However, anyone who uses an earlier version of Word may be prevented from or have problems editing parts of the document that were created by using new or enhanced features.Document elements that behave differently in compatibility modeThe elements listed in the following table might change permanently when you work in compatibility mode.
Important: Do not use AutoRecover as a substitute for regularly saving your files by using AutoSave (see below) or by clicking Save. Saving your files frequently is the best way to preserve your work.You can set how frequently these AutoRecover files are saved. For example, if you set AutoRecover to save every 5 minutes, you may recover more information in the event of unexpected shutdown — such as from a power outage — than if it's set to save every 10 or 15 minutes.If you manually save your file, the previous AutoRecover files are removed because you've just saved your changes.AutoSave is a different feature which automatically saves your file as you work - just like if you save the file manually - so that you don't have to worry about saving on the go. On the Mac, AutoSave is available in Excel, Word, and PowerPoint for Office 365 for Mac subscribers. When AutoSave is turned on AutoRecover files are rarely needed.For more information see. Recover a file saved by AutoRecoverNormally, the application will automatically recover your work the next time that you open the app following a power failure or other unexpected shutdown by detecting that an AutoRecover file exists and automatically opening it. If you want to keep the recovered file, you should immediately save it before closing or editing it.If you want to find any AutoRecovered files on your computer, switch to Finder,then click Go Go To Folder (or press SHIFT + COMMAND + G) and enter the appropriate folder path from the table below.
Replace with your username:Excel/Users//Library/Containers/com.microsoft.Excel/Data/Library/Application Support/MicrosoftPowerPoint/Users/ /Library/Containers/com.Microsoft.Powerpoint/Data/Library/Preferences/AutoRecoveryWord/Users/ /Library/Containers/com.Microsoft/Data/Library/Preferences/AutoRecovery. Notes:.The AutoRecovery folder is a hidden folder, so you probably won't see it if you just try to navigate to it in Finder. Use the Go To Folder tool and enter the full path to get around this.If you close a file and click Don't Save, the AutoRecover file will be deleted because Office assumes that everything is ok and the AutoRecover file isn't needed.Change how frequently AutoRecover files are automatically saved in Word, PowerPoint, or Excel.On the Word, PowerPoint, or Excel menu, click Preferences.Click Save.In the Save AutoRecover info box, enter how frequently you want the program to save documents.Change where to save AutoRecover files in Word.
Note: The AutoRecover file location can't be changed in Excel or PowerPoint.
![](/uploads/1/2/6/6/126619550/803551652.jpg)