TechNet
Export (0) Print
Expand All

Office Online Service Description

 

Applies to: Office 365

Topic Last Modified: 2016-08-23

Office Online (formerly Office Web Apps) opens Word, Excel, PowerPoint, and OneNote documents in your web browser. Office Online makes it easier to work and share Office files from anywhere with an Internet connection, from almost any device. Microsoft Office 365 customers with Office Online can view, create, and edit files on the go.

To compare features across plans, see Compare Office 365 for Business plans.

Need help figuring out which Office solution best fits your organization? The following table compares Office Online feature capabilities to feature-rich Microsoft Office desktop apps. Use the table to discover what features are available in Office Online and then click on the feature name to read a brief description about how that feature works. You may discover that some people in your organization may need the advanced charting capability of the Excel desktop app while others may only need to view and lightly edit Word documents and PowerPoint presentations with Office Online.

NoteNote:
A limited selection of Office features have been chosen to represent the advanced capabilities of the Office desktop suite. The table is not a comprehensive list of Microsoft Office 2013 features.
Microsoft Office 365 ProPlus is a monthly subscription offer of the latest Office desktop suite.
Microsoft Office Web Apps Server 2013 on-premises customers get an Office Online editing license if they have purchased an Office desktop suite license (such as Office Professional Plus, Office Standard, or an Office 365 ProPlus license).

 

Application features

Office Online

Office Online operated by 21Vianet11

Desktop app (e.g. Office 365 ProPlus, or Office Professional Plus 2013)

Word

Word Online

Word Online operated by 21Vianet11

Word 2013

Alignment guides and live layout

No

Yes

Apply styles

Yes

Yes

Autosave

Yes

Yes

AutoText

Yes10

Yes

Browse and start from professionally designed templates

No

Yes

Bullets and numbering

Yes

Yes

Captions

No

Yes

Citations and bibliography

No

Yes

Clipboard

Yes

Yes

Collaboration- advanced

No

Yes

Content controls

Yes10

Yes

Cover pages

Yes10

Yes

Creation of advanced document elements

No

Yes

Document parts and themes

No

Yes

Dropbox

Yes

Yes

Equations

Yes10

Yes

Find and Replace

Yes

Yes

Font formatting

Yes

Yes

Footnotes and endnotes

Yes

Yes

Full fidelity reading view

Yes

Yes

Graphic effect pre-sets

Yes10

Yes

Headers and footers

Yes

Yes

Hyperlinks

Yes

Yes

Index

Yes10

Yes

Insert online pictures

Yes

Yes

IRM and password protection

No

Yes

Lists

Yes

Yes

Mail merge

No

Yes

Office Add-ins

Yes5

Yes

Offline viewing and authoring

No

Yes

Page breaks

Yes

Yes

Page layout tools

Yes

Yes

Page layout tools- advanced

No

Yes

Page numbers

Yes

Yes

Paragraph formatting

Yes

Yes

Picture tools

Yes

Yes

Preformatted font/color schemes

Yes10

Yes

Present online

No

Yes

Print to PDF

Yes

Yes

Printing- advanced

No

Yes

Proofing tools

Yes

Yes

Proofing tools- advanced

No

Yes

Real-time co-authoring

Yes1

No1

Reference tools

No

Yes

Rendering of text boxes/shapes

Yes10

Yes

Rich media

No

Yes

Rich table formatting

Yes

Yes

Save As and Download a copy

Yes

Yes

Save as PDF

Yes10

Yes

Share

Yes

Yes

Simple table creation

Yes

Yes

SmartArt

Yes

Yes

Table of Authority

No

Yes

Table of Contents

No

Yes

Tell Me

Yes

No

Undo and Redo

Yes

Yes

VBA and Forms scripts

No

Yes

View and add comments

Yes

Yes

Word count

Yes

Yes

Zoom

Yes

Yes

Excel

Excel Online

Excel Online operated by 21Vianet11

Excel 2013

Add hyperlinks

Yes

Yes

Advanced time filtering (Timeline slicer)

No

Yes

Alignment

Yes

Yes

Apply conditional formatting

No

Yes

Apply data validation to cells

No

Yes

Apply smart/recommended formatting

No

Yes

Audio notes recording

No

Yes

Autocomplete

Yes

Yes

Auto Sum

Yes

Yes

Chart animations adapt to new data

No

Yes

Comment creation

Yes

Yes

Copy and paste

Yes

Yes

Create external data connections

No

Yes

Create tables

Yes

Yes

Creation of advanced analysis views (Power View, PowerPivot, Slicers)

No

Yes12

Drag and drop cells

Yes

Yes

Dropbox

Yes

Yes

Embed Workbook on Web or Blog Page (OneDrive)

Yes

No

Fill Handle

Yes

Yes

Find

Yes

Yes

Font and cell formatting

Yes

Yes

Formula bar

Yes

Yes

Formula tools- advanced

No

Yes

Freeze panes

No2

Yes

Full fidelity reading view

Yes

Yes

Functions (approx. 400)

Yes

Yes

GoTo

Yes12

Yes

Hide/unhide rows, columns, and sheets

Yes

Yes

Insert charts

Yes

Yes

Insert/delete rows and columns

Yes

Yes

Merge cells

Yes

Yes

Number formatting

Yes

Yes

Office Add-ins

Yes5

Yes

Offline viewing and authoring

No

Yes

Post to Social network and present online

No

Yes

PowerPivot viewing

Yes12

Yes

Power View viewing

Yes12

Yes

Print

Yes

Yes

Real-time co-authoring

Yes1

No1

Recommended chart creation and editing with formatting controls

No

Yes

Refresh existing data connections

Yes

Yes

Rename and add sheets

Yes

Yes

Rename file while workbook is open

Yes

No

Replace

No

Yes

Rights Management: IRM and password security

No

Yes

Save or Download a copy

Yes

Yes

Share

Yes

Yes

Sheet protection

Yes12

Yes

Slicer viewing

Yes12

Yes

Sort and filter data

Yes

Yes

Sorting pages

Yes12

Yes

Spreadsheet audit and compliance

No

Yes

Status bar aggregates

Yes

Yes

Surveys

Yes

No

Tell Me

Yes

No

Undo and redo

Yes

Yes

VBA and macro scripting

Yes12

Yes

View 3D charts

Yes

Yes

What if analysis tools

No

Yes

OneNote

OneNote Online

OneNote Online operated by 21Vianet11

OneNote 2013

Advanced collaboration: New content shows as unread, presence

No

Yes

Apply tags

Yes

Yes

Bullets and numbering

Yes

Yes

Clipboard

Yes

Yes

Clipping experiences

No

Yes

Co-authoring

Yes1

Yes1

Create and manage pages and sections

Yes

Yes

Download copy of embedded Office files

Yes

Yes6

Dropbox

Yes

Yes

Edit embedded files

No

Yes

Equations

Yes

Yes

Hyperlinks

Yes

Yes

Image optical character recognition (OCR)

No

Yes

Inking: ink-to-text and math, customizable pens, drawing tools

No

Yes

Ink viewing

Yes

Yes

Navigation

Yes

Yes

Notebook management: Cross section/notebook page filing, section re-order, create/delete section groups

Yes8

Yes

Outlook integration (tasks)

No

Yes

Paragraph formatting

Yes

Yes

Pictures

Yes

Yes

Print

Yes

Yes

Proofing tools

Yes

Yes

Rights Management: Apply and consume IRM and password security

No

Yes

Search by: tag, title, author/date, audio notes

Yes7

Yes

Search (on page, within sections)

Yes

Yes

Share

Yes

Yes

Show or hide authors

Yes

Yes

Styles

Yes

Yes

Tables

Yes

Yes

Template support

No

Yes

Undo and Redo

Yes

Yes

Video playback

No

Yes

View previous page versions

Yes

Yes

8d7364c3-f08c-43b5-801a-d198bedf0cdf#bkmk_AppsforOffice

Yes5

Yes

PowerPoint

PowerPoint Online

PowerPoint Online operated by 21Vianet11

PowerPoint 2013

Alignment, bullets, numbers

Yes

Yes

Apply basic transitions and animations

Yes

Yes

Apply rich formatting to text, shapes, and pictures

No

Yes

Apply themes and theme variants

Yes

Yes

Arrange objects

Yes

Yes

Broadcast slide show

No

Yes

Clipboard

Yes

Yes

Create and manage slides

Yes

Yes

Create custom animation

No

Yes

Design tools- advanced

No

Yes

Embed presentation on web or blog page

Yes

No

Font formatting

Yes

Yes

Full fidelity reading view

Yes

Yes

Full ink support

No

Yes4

Full selection of animations and transitions

No

Yes

Headers and footers

No

Yes

Hyperlinks

Yes

Yes

Insert rich media

No

Yes

Integration with Excel for charts

No

Yes

Navigation— slide sorter

Yes

Yes

Office Add-ins

Yes5

Yes

Offline viewing and authoring

No

Yes

Picture cropping

Yes13

Yes

Pictures

Yes

Yes

Presenter view

No

Yes

Present online through Skype for Business or the Office Presentation Service

Yes13

Yes

Print to PDF

Yes

Yes

Proofing tools

Yes

Yes

Real-time co-authoring

Yes3

No3

Reviewer tools- advanced

No

Yes

Rights Management: Apply and consume IRM and password security

No

Yes

Run slide show

Yes

Yes

Save As or Download a copy

Yes

Yes

Shapes

Yes

Yes

Share

Yes

Yes

Slide show

Yes

Yes

SmartArt

Yes

Yes

Table creation/editing and formatting

Yes13

Yes

Tell Me

Yes

No

Undo and redo

Yes

Yes

View and add comments

Yes

Yes

View and edit slide notes

Yes

Yes

WYSIWYG viewing

Yes13

Yes

NoteNote:
1   Word 2013 supports simultaneous editing, but there is no presence indication, and changes can’t be seen by multiple authors until the document is manually saved.
2   You can view freeze panes created using Excel 2013 desktop app, but you cannot create freeze panes in Excel Online.
3   PowerPoint 2013 supports simultaneous editing, but there is no presence indication, and changes can’t be seen by multiple authors until the presentation is manually saved.
4   The device you’re working on needs to support ink.
5 Some, but not all, Office add-ins are available.
6 In the desktop version, there is not a "download" option, but you can Save As to another location.
7 You can search on Page or Section, but not entire notebook or across notebooks (as you can in the desktop version).
8 In OneNote Online, you can move sections within a notebook, and copy and paste pages from one section to another.
10 Not available in Word Online operated by 21Vianet.
11 The Office 365 operated by 21Vianet version of Office 365 is specific to China.
12 Not available in Excel Online operated by 21Vianet.
13 Not available in PowerPoint Online operated by 21Vianet.
NoteNote:
When you open an Office document, either as an Outlook email attachment or from a SharePoint document library, the document will launch in Office Online and will be read-only. To edit a document in Office Online (edit mode), you need an Office 365 suite license, such as Office 365 Enterprise E1. To edit a document in the desktop app, you need an Office desktop suite license, such as an Office 365 ProPlus subscription or an installed version of Office Professional Plus 2010.

 

Word documents created in Word 2.0 or later

View mode

Edit mode

Open XML (.docx)

Yes

Yes

Binary (.doc)

Yes

Converted to .docx

Macro (.docm)

Yes1

Yes1

Other (.dotm, .dotx)

Yes

No

OpenDocument (.odt)

Yes

Yes

Portable Document Format (.pdf)

No

No

Excel workbooks created in Excel 97 or later

View mode

Edit mode

Open XML (.xlsx, .xlsb)

Yes

Yes

Binary (.xls)

No

No

Template (.xlt, .xltx)

No

No

Macro (.xlsm)

Yes1

Yes2

OpenDocument (.ods)

Yes

Yes

PowerPoint presentations created in PowerPoint 97 or later

View mode

Edit mode

Open XML (.pptx, .ppsx)

Yes

Yes

Binary (.ppt, .pps)

Yes

Converted to .pptx or .ppsx

Template (.pot, .potx)

Yes

No

Macro (.pptm, .potm, .ppam, .potx, .ppsm)

Yes1

No

Add-ins (.ppa, .ppam)

No

No

OpenDocument (.odp)

Yes

Yes

OneNote notebooks created in OneNote 2010 or later

View mode

Edit mode

Open XML (.one)

Yes

Yes

NoteNote:
1 Macros can’t be run or changed.
2 If macros exist, users are prompted to have a copy of the file with the macros removed.
NoteNote:
Newer file formats (such as .docx, .xlsl, and .pptx) can be created in Office 2013, 2010, or 2007, or in Office 2000 and later with the compatibility pack

Users may be able to use Office Online even when they don’t possess an Office Online license. You can change the default setting and work around this issue by using one of the following procedures.

Set the OpenInClient feature for a site collection in SharePoint Online
  1. In the SharePoint site collection, choose the Settings icon > Site Settings.

  2. On the Site Settings page, under Site Collection Administration, choose Site Collection Features.

  3. On the Features page, for the Open Documents in Client Applications by Default feature, choose Activate to enable the OpenInClient feature (documents will open in the client application).

Set the default open behavior for a document library in SharePoint Online
  1. Navigate to the site containing the library you want to change.

  2. On the document library page, select the Library tab.

  3. In the Settings group, click Library Settings.

  4. On the Document Library Settings page, click Advanced settings.

  5. On the Advanced Settings page, in Opening Document in the Browser, select Open in the client application. When a user chooses a document in this library, the document will open in the corresponding client application if it's available.

    NoteNote:
    Office Online may be used when the browser’s add-on (for example, SharePoint OpenDocuments Class) is disabled.
  6. Click Save to save your settings.

Change Outlook Web App mailbox policy properties
  1. Connect to Exchange Online and start Windows PowerShell.

  2. At the command prompt, type:

    Set-OwaMailboxPolicy -Identity "OwaMailboxPolicy-Default" -WacViewingOnPublicComputersEnabled $false
     Set-OwaMailboxPolicy -Identity "OwaMailboxPolicy-Default" -WacViewingOnPrivateComputersEnabled $false
    

Comments or questions about this topic? Send your feedback to Office 365 Service Description Feedback. Need help with Office 365? Visit the Microsoft support center.

 
Show:
© 2016 Microsoft