Opening Online Files Locally
You can open the web application version of an Office file using your Office 2010 desktop version to take advantage of the full feature set of the program. For example, you can open the changed file and make more complex changes, save it directly back online (the default), or you can save it under another name, or use other options like those in Backstage view.
Click Open in Excel.
Click OK to accept the warning about harmful files.
The file opens in the desktop application with the name from the web application. Notice that any charts in the worksheet still retain their original effects.
You can click Options to clear the Security Warning about any external data connections to other databases that the file might access.
You can click another worksheet to access its data.
You can work with the data that has been added or changed online by those with permission to access your workspace folder.