Known issues in Excel 2011

You cannot create Slicers with Excel 2011. If you open an Excel for Windows file that contains Slicers, Excel 2011 will open it as read-only and Slicers will not be visible.

When you drag the mouse to select multiple objects, the objects are not selected. To select multiple objects, press and hold SHIFT, then click to select or unselect objects. To select all objects, click one object, and then press COMMAND+A.

If you set your worksheet scaling to Fit to: 1 page(s) wide by 1 pages(s) tall and your worksheet contains a column wider than 8 inches, previewing or printing the worksheet will return blank pages. To resolve this issue, adjust column widths to less than 8 inches.

Sheets that are created by using Excel for Windows can be customized to display right-to-left. When you open a sheet that has right-to-left direction in Excel for Mac, the direction is not retained and the sheet displays left-to-right.

When the active sheet contains a chart and you select the option to print the entire workbook, the chart becomes blank. This issue affects only the display and does not affect the printed output.

When you select a chart and try to print it, the option to print a selection is not available. To print only the chart, move the chart to a different sheet and then print that sheet.

Earlier versions of Office for Mac included Organization Chart, a tool for creating and editing organization charts. Microsoft Office for Mac 2011 does not include Organization Chart. When you open a document that contains an object that was created by using Organization Chart, you can view it, but you cannot edit it.

If you are recording a macro, the actions that you perform in the Format Chart dialog box are not recorded. To work around this issue, use the Chart tab on the ribbon when you record a macro.

When you sort numeric values in a PivotTable, only the values in one field will be sorted. To work around this issue, select each field and sort the numeric values in the field.

Excel 2011 includes an expanded color palette, themes, and cell formatting options that are lost when you save the workbook in an earlier file format, such as .xls, or if the workbook is opened in an earlier version of Excel.

Workbooks created by using Excel for Windows might contain ActiveX controls that cannot be displayed when the workbook is opened in Excel for Mac.

When you remove personal information from a file in Excel Preferences, any custom file properties that the file contains are not removed.

If you select an entire sheet and then attempt to remove duplicate rows, Excel quits unexpectedly. To avoid this issue, select a smaller range to remove duplicates from.

If you run Office in a NetBoot or network home folders configuration, you cannot save documents to Windows Live SkyDrive or SharePoint if they are located on a network location that uses the AFP or NFS file system.

You cannot open files located on SharePoint or Windows Live SkyDrive from Safari or Mozilla Firefox until you have opened Word, Excel, or PowerPoint at least one time.

When you set a custom dictionary to work only for a specific language, the language setting is not used when you check the spelling in Excel or PowerPoint.

If you clear the Save password in my Mac OS X keychain check box when you access the Active Directory Rights Management Services (AD RMS) server, you will have to sign in multiple times. To work around this issue, make sure that the Save password in my Mac OS X keychain check box is selected.

Per Apple guidelines, when you paste a vector PICT image, it is saved as PDF instead of PICT, and you cannot ungroup the PDF image.

If you add a link to a picture that is located on a Web site, the next time that you open the file, the picture is displayed as a red X. This occurs because the application does not recognize the Web site path. To work around this issue, on the Web site, copy the image, and then paste it into the Office for Mac application.

If you set Parental Controls on the Mac OS, Office for Mac applications might not work correctly. To resolve the issue, on the Apple menu, click System Preferences, click Parental Controls, and then turn off Parental Controls.

Office for Mac displays no clip art in the Entertainment, Emotions, or Food and Dining categories in the Clip Art Gallery. To work around the issue, search for the following clip art:

A document that has a hyperlink that includes non-Latin characters, a shape, or is otherwise corrupted, might prevent you from saving or editing the hyperlink. To work around the issue, delete the object that you added the hyperlink to.

The following workflows included with Office for Mac do not work:

Microsoft Office for Mac 2011 does not let you print a Visual Basic project. To work around the issue, copy the code of your Visual Basic project, paste it into a text-editing program, and then print.