You expect Excel for Mac 2011 to open Excel files, of course, but the program can do more than that. You can actually open, work on, and save a file in several formats. Choose File→Save As and then click Format to open the pop-up menu. Excel can open and save in the formats listed in this Format pop-up menu.
You have several options for file formats besides Excel’s default (.xlsx) format:
- Excel Template (.xltx): Saves the workbook as a template, which you can open in the My Templates section of the Excel Workbook Gallery. You can also open templates by choosing File→Open and selecting Excel Templates from the Enable pop-up menu. This format does not have macros and is another open XML format.
- Excel Macro-Enabled Workbook (.xlsm): Workbooks in this XML format contain Visual Basic for Applications (VBA) programming language code, or Excel 4.0 macro code. When opening this format file, Excel displays a prompt asking whether you want to remove the macros contained in the file. The default is Disable Macros. You must instead click Enable Macros if you want macros to run.
- Excel Macro-Enabled Template (.xltm): The same as .xlsm, except this is a template. The macro warning dialog displays when you open a workbook in this format, and you must click Enable Macros if you want macros to run.
- Excel Add-In (.xlam): Saves a macro-enabled workbook as an Excel add-in.
- Excel Binary Workbook (.xlsb): This is the most compact file format, and is recommended for large files. This format doesn’t conform to open source standards.
- Comma Separated Values (.csv): Saves a worksheet data table as text separated by commas. This format is text only. All other content is discarded.
- Web Page (.htm): Save the workbook in a format that Web browsers understand and can display. Excel creates a file in HTML format, along with a supporting folder. Upload both the file and folder to a Web server if you want to share your workbook via the Internet.
Excel can open and save Web pages in HTML (HyperText Markup Language) format and do great things with Web tables and data from the Web, but don’t uninstall your HTML (Web page) code editor. Excel can’t replace that.
![For For](/uploads/1/2/5/8/125872054/664275917.jpg)
How to open Microsoft Excel spreadsheets in Apple Numbers on a Mac. If you use Microsoft Excel on your Mac, you can save the spreadsheets you create and open them in Numbers, Apple’s.
-->Symptoms
One or more toolbars are missing and cannot be added in Microsoft Excel for Mac.
Cause
There are two possible causes of this behavior:
- The oval button in the upper-right corner of the document was clicked. This button 'toggles' the display of toolbars on and off.
- There is an issue with Excel preferences.
Resolution
To resolve this issue, use the following methods in order.
Method 1: Make sure that toolbar display is not turned off
- In the upper-right corner of the Excel window, click the oval button.NoteWhen this button is clicked, the toolbars are hidden (in any Microsoft Office for Mac application). A second click causes the toolbars to be displayed.
- If the toolbars reappear, quit Excel, and then restart Excel to make sure that the appropriate toolbars are displayed.
If Method 1 did not resolve the problem, try Method 2.
Method 2: Remove the Excel preferences
Step 1: Quit all applications
To quit active applications, follow these steps:
- On the Apple menu, click Force Quit.
- Select an application in the 'Force Quit Applications' window.
- Click Force Quit.
- Repeate the previous steps until you quit all active applications.
Warning
When an application is force quit, any unsaved changes to open documents are not saved.
Step 2: Remove the Excel Preferences
To remove the Excel preferences, follow these steps.
- Quit all Microsoft Office for Mac applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder. Click View, click Arrange by, and then select Name.
- Look for a file that is named com.microsoft.Excel.plist.
- If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.
- If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.plist file to the trash.
- Quit all Office for Mac applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder.
- Open the Microsoft Folder.
- Look for a file that is named com.microsoft.Excel.prefs.plist.
- If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.
- If you locate the file and move it to the desktop, start Excel, and then check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.prefs.plist file to the trash.
- Close all Office applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder.
- Open the Microsoft Folder.
- Open the Office 2008 or Office 2011 folder.
- Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.
- If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. If the problem seems to be resolved, you can move the Excel Toolbars (12) file or the Microsoft Excel Toolbars to the trash.
Note
If the problem still occurs after you follow these steps, the problem is not related to these files. If the problem no longer occurs, one of these files was causing the problem. If this is the case, restore the files to their original location one at a time. Test the application after you restore each file. Continue to do this until the problem occurs again. When the problem recurs, you can then assume that it is caused by the last file that you restored. Drag that file to the trash.