Microsoft Office Tutorials and References
In Depth Information
(Note the sub-legend beneath this command states “Refresh the data connection for the currently
selected PivotTable.”)It also means that any chart you’ve added to the Web App version (after it’s been
constructed on your PC and then returned to the cloud) will be automatically updated when you change
any of the contributing data—as you’re changing them back on the cloud.
To sum up here—Working with Excel on the Excel Web App 2010 grants you three different levels
of wor kbook access:
View —lets you view the worksheet in a read-only state; you can however refresh
a PivotTable or chart in View if another user has changed the data.
Edit in Browser —lets you enter and sort and filter data, and change formatting.
Open in Excel —opens the workbook in Excel proper, allowing you to implement
any and all of the application’s features. Saving any changes here saves them
back to the cloud, whereupon it’s made available back in the Excel Web App
You can al so i n i ti ate a br an d n e w, We b App- base d wor kbook by g e tti n g i n to y our Sky Dr i v e ,
clicking the folder in which you want the workbook to appear, and clicking New Microsoft Excel
Workbook Create , and enter the workbook name (you’ll note here that you can also mint new
docume n ts i n the We b App for othe r Offi ce appl i cati on s, too). You’ l l be br oug ht to a bl an k wor kbook,
and you’re ready to go. To delete a workbook, click on the book name in its folder, and click Delete.
A few words may also be in order about the File tab, presented in slightly different guises both in
the initial Web App workbook view (before you click an edit option) as well as the Edit in Browser view.
In that first View, clicking a file triggers this drop-down menu (Figure 10-11):
Figure 10–11. The file drop-down mnenu in the initial Web App view of a workbook