Significant improvements and new functionality make it easier to view and work with your Excel data in a web browser. You'll see these improvements when you save a Microsoft Excel 2010 workbook to a SharePoint Services site that has Office Web Apps deployed.
When you save a workbook to a site on a SharePoint 2010 server with Office Web Apps deployed, users can edit, format, and work with data in ways that weren't possible the browser connected to a server running SharePoint 2007.
In this article
Improved Web browser support
Viewing a workbook in the browser is supported by Internet Explorer 7 and FireFox 3.5 Web browsers on a PC, and the Safari 4 Web browser on a Macintosh. However, some Excel features are not fully supported in FireFox and Safari browsers, such as rotated text and gradients.
Top of Page
Working with data in Office Web Apps
When you view a workbook on a server with Office Web Apps deployed, you'll see an Edit in browser button.
Use the new editing capability to:
- Add, change, or delete data.
- Collaborate with other users by working on the same worksheet at the same time.
- Insert or delete cells, rows, or columns.
- Create filters and apply sorting to data that did not have filtering or sorting enabled when it was saved to the server.
- Enter and edit formulas.
- Work with most of the same worksheet functions you use in an Excel workbook.
- Change data types.
- Quickly add columns or rows of data by using the Sum button.
- Copy, cut, and paste cells.
- Size column widths and rows heights.
- Perform multiple-level undo operations.
Top of Page
Features new to Excel 2010 supported in the browser
Sparklines Available in Excel 2010 workbooks only, sparklines are tiny charts that appear in the background of a cell. Sparklines are connected to underlying data and show trends for that data in chart format, such as a line, column, or win-loss diagram.
You create a sparkline in an Excel workbook, and after you save that workbook to a SharePoint site, you can view and change the data and watch the sparkline update dynamically without having to recalculate or refresh the browser page.
The following image shows a line sparkline with all data points visible.
Slicers Available in Excel 2010 workbooks only, you use slicers with PivotTable reports (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.). You create one or more slicers based on a PivotTable in an Excel workbook, and after you save that workbook, you use one or more slicers to drill down on data in your PivotTable in a way that is easier than ever when viewing data in a web browser.
Top of Page
Earlier Excel features that are now supported in the browser
Many features that were not supported when viewing a workbook saved on a SharePoint 2007 server in the browser are now supported:
- Navigating within and editing worksheet cells and Excel tables.
- Images, such as clip art, that are inserted in an Excel 2010 workbook will appear in the browser view.
- When you view a workbook containing unsupported features that cannot be shown or worked with in the browser, in most cases, the workbook will still be displayed. For features that aren’t supported, there are improved warning messages.
- Comments in a workbook will not prevent the workbook from being displayed in the browser, but the comments will not appear in the browser view. Open the workbook in the Excel desktop program to see any comments.
Note Loading a shared workbook in the browser is not supported.
Top of Page
Improvements to the browser viewing experience
- A ribbon that is visually similar to the Excel 2010 Ribbon appears when you click Edit in the browser. This ribbon contains a Home tab, Insert tab, and File tab.
- When displaying a worksheet in a browser from a workbook saved on a SharePoint 2007 server, the worksheet grid was limited to showing 20 columns and 75 rows at any given time, although you could click the Move Right, Move Left, Move Down, and Move Up buttons to see additional rows and columns. Now, vertical and horizontal scroll bars are enabled so that you can easily scroll throughout the grid for easy access to all the data – all the way up to the limit of rows and columns that the Excel 2010 desktop program allows.
- Instead of being limited to selecting a single worksheet cell by using the mouse, you can now use the TAB key, arrow keys, the Page Up, Page Down, Home, and End keys, and key combinations (such as CTRL+Home) to move throughout the worksheet.
- You can select contiguous (that is, connected) multiple cells by using the mouse and the keyboard. However, it is not possible to select noncontiguous cells (for example; selecting only cells A1 and B5), nor can you use the CTRL+Enter keyboard combination on formulas that you enter in multiple cells. Also, creating an array formula in the browser is not supported.
- You can insert individual cells or entire columns and rows in the worksheet.
- You can size column width and row height, but auto sizing (that is, double-clicking a row or column boundary) is not supported.
- You can navigate to a cell that contains a hyperlink without launching a new browser window. You can insert a new hyperlink by using the Hyperlink command (on the Insert tab).
- You can insert Excel tables, convert a range of cells to a table, and navigate within tables. You can also add cells, delete cells, and change data in an Excel table.
- In a table, you can use the Table Options command (on the Home tab) to toggle the header row and the total row.
Top of Page