Article ID: 2028380 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you try open an Office file that is stored on a Microsoft SharePoint Server 2010 or Microsoft SharePoint Foundation 2010 website by using Office Web Apps, you receive the following message:

Open Document
You are about to open:
Name: <filename>
From: <sitename>
How would you like to open this file?


Or, you receive the following message when you double-click a file that is stored in OneDrive (formerly SkyDrive) to view the file by using Office Online:

File Download
Do you want to open or save this file?

Name: <filename>
Type: <File Type>
From: livefilestore.com


Cause

This issue occurs because the operation that you requested in Office Online or Office Web Apps does not support the file format of the file.

Resolution

To view or edit the file in Office Online or Office Web Apps, open the file in Microsoft Office Excel 2010, in Microsoft Office PowerPoint 2010, or in Microsoft Office Word 2010, and then save the file by using one of the supported formats. The following table shows the recommended file formats for Office Online and Office Web Apps.

Collapse this tableExpand this table
ProductFile format
Microsoft Excel Online, Excel Web AppExcel Workbook (*.xlsx)
Excel Workbook Binary (*.xlsb)
Microsoft Word Online, Word Web AppWord Document (*.docx)
Microsoft PowerPoint Online, PowerPoint Web AppPowerPoint Presentation (*.pptx)

Notes
  • If you save an XLS file that contains macros as an .xlsx file, the macro will not be saved.
  • Macros will not run in Microsoft Excel Online or Excel Web App.

More information

To view or edit in Office Online, use the following table to check which file formats are supported.

Microsoft Word
Collapse this tableExpand this table
File formatView in Word Online or Word Web AppEdit in Word Online or Word Web App
Open XML (.docx)YesYes
Binary (.doc)YesYes, Word Online or Word Web App converts the .doc file to a .docx file to allow you to edit the file but you must save the file in as a .docx file to save your changes.
Macro (.docm)YesYes, but macros do not work.
Templates (.dotm, .dotx)YesNo, you must open the template in the client.
Other file formats (.dot, .mht, .mhtml, htm, .html, .odt, .rtf, .txt, .xml, .wps, .wpd)NoNo

Microsoft Excel
Collapse this tableExpand this table
File formatView in Excel Online or Excel Web AppEdit in Excel Online or Excel Web App
Open XML (.xlsx)YesYes
Binary (.xlsb)YesYes
Binary (.xls)Yes on OneDrive (formerly SkyDrive)

Not on SharePoint
Yes on OneDrive (formerly SkyDrive).

Not on SharePoint.
Macro (.xlsm)YesYes. However, you are prompted to create a copy of the file that has the macros removed when you save the changes that you have made.
Other file formats (.xltx, .xltm, .xlam, .xlm, .xla, .xlt, .xml, .xll, .xlw,ods, .prn, .txt, .csv, .mdb, .mde, .accdb, .accde, .dbc, .igy, .dqy, .rqy, .oqy, .cub, .uxdc, .dbf, .slk, .dif, .xlk, .bak, .xlb)NoNo

Microsoft PowerPoint
Collapse this tableExpand this table
File formatView in PowerPoint Online or PowerPoint Web AppEdit in PowerPoint Online or PowerPoint Web App
Open XML (.pptx, .ppsx)YesYes
Binary (.ppt, .pps)YesYes, PowerPoint Online or PowerPoint Web App converts the .ppt or .pps file to a .pptx or .ppsx file to allow you to edit the file but you must save the file in as a .pptx or .ppsx file to save your changes.
Macro (.pptm, .potm, .ppam, .potx, .ppsm)YesNo
Other file formats (.pot, .htm, .html, .mht, .mhtml, .txt, .rtf, .wpd, .wps, .ppa, .odp, .thmx)NoNo



Properties

Article ID: 2028380 - Last Review: May 4, 2014 - Revision: 6.0
Applies to
  • Microsoft Excel Online
  • Microsoft Word Online
  • Microsoft PowerPoint Online
  • Microsoft Excel Web App
  • Microsoft Word Web App
  • Microsoft PowerPoint Web App
Keywords: 
kbinfo kbprb kbtshoot kbsurveynew KB2028380

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com