Limitations of Workplace On-line Functions

Microsoft Workplace 365 helps each the desktop variations of Microsoft Workplace purposes, that are put in on a workstation, and the web variations of Workplace purposes that may be opened, seen, and edited in a Internet browser. Nonetheless, there are numerous variations between the 2 variations. The net variations of Workplace purposes are often referred as Workplace On-line apps (e.g., Phrase On-line app), whereas the desktop purposes that you simply set up in your workstation are known as Workplace Desktop apps (e.g., Excel Desktop app). Due to this fact, that’s the terminology I’ll use on this article.

The Workplace On-line variations should not provided as a alternative for the full-featured desktop Workplace purposes, they’re solely provided so customers can shortly learn an Workplace doc on-line or make some minor modifications to the appliance as a result of many of the options within the desktop variations should not supported within the restricted on-line variations. The Workplace On-line apps in Workplace 365 can positively come helpful, however as you’ll uncover after studying this text, there are simply too many limitations in Workplace On-line apps that forestall a overwhelming majority of organizations from utilizing them as a alternative for desktop apps, that are full-featured purposes with all of the bells and whistles.

The Workplace On-line apps may match for a person at residence, nevertheless it’s arduous to discover a enterprise that’s completely utilizing Workplace On-line apps as a result of it’s simply not sensible. Use the next data to search out out which options are lacking from the Workplace On-line apps in Workplace 365. If you happen to don’t see a characteristic that’s obtainable in an Workplace Desktop app listed right here, then likelihood is that it might work within the Workplace On-line app. In different phrases, this can be a record of options which might be NOT AVAILABLE in Workplace On-line. Though I used different Microsoft paperwork as a supply of this text, the first supply of data for this text was Microsoft’s TechNet doc Workplace On-line Service Description.

Phrase On-line Limitations

In accordance with Microsoft, as of Might 30, 2017, the next limitations apply to Phrase On-line. Please word that this isn’t a whole record. Options that aren’t supported in Phrase On-line are supported in Phrase desktop app.

1. Phrase On-line solely helps pasting of textual content from exterior Phrase in plain textual content. So, all of the formatting must be manually utilized to the textual content you previous into Phrase On-line.
2. Pasting of textual content formatted exterior Phrase On-line as rows and columns or as sub-items in an inventory, the desk, or hierarchical construction Just isn’t supported. If you wish to copy a desk. It’s important to copy and paste each single cell manually into Phrase On-line.
3. You can’t paste photos in Phrase On-line from different packages or paperwork exterior of Phrase On-line. You possibly can solely copy photos from the Internet and paste it into Phrase On-line.
4. Hyperlinks are pasted in Phrase On-line as static textual content, which means you received’t have the ability to click on on the URL to get to the hyperlink.
5. You can’t open paperwork encrypted with a password and you can’t apply password-protection to a doc.
6. Captions should not obtainable.
7. Citations and bibliography will not be obtainable.
8. Observe Modifications characteristic will not be obtainable.
9. Mail merge will not be supported.
10. Merging of paperwork will not be supported.
11. You can’t examine paperwork.
12. Paperwork can’t be mixed.
13. AutoText characteristic will not be obtainable.
14. Cowl pages should not supported.
15. You can’t create a Desk of Contents, however you may view it if the doc you open comprises it.
16. Desk of Authority can’t be created.
17. You can’t index paperwork.
18. The equations should not supported.
19. Watermarks can’t be used.
20. InkEditor will not be supported.
21. Doc components and themes (content material controls, pre-formatted collections of shade scheme, font scheme and graphic impact pre-sets) should not obtainable.
22. Offline viewing and authoring of paperwork will not be supported as a result of Workplace On-line requires entry to the Web.
23. You can’t create or edit paperwork which might be protected with Data Rights Administration (IRM).
24. Energetic X controls, embedded OLR objects, and a signature line might be seen in View mode, however they seem as placeholders in Edit mode that may be deleted however not edited. Additionally, they will’t be moved or resized.
25. Superior desk options, resembling customized desk kinds, cell measurement, textual content path, and kind order should not supported, however you may create a primary desk and add/delete rows and columns.
26. You can’t insert on-line movies.
27. PowerPoint movies can’t be inserted.
28. You can’t show rulers and tips.
29. Adjusting line spacing will not be supported.
30. Superior printing options, resembling printing markups and doc properties should not obtainable.
31. Inserting SmartArt will not be supported.
32. You possibly can’t insert WordArt.
33. Desk kinds, cell measurement, textual content path, and kind order can’t be configured.
34. Saving paperwork within the .doc or .dot codecs will not be supported.
35. Linked photos and embedded recordsdata should not displayed. They
36. Inserting shapes, charts, and textual content containers will not be supported.
37. Display screen pictures can’t be created instantly, however screenshots in current paperwork will show as pictures.
38. Superior proofing instruments, resembling including new phrases to the spell verify dictionary, making use of a customized dictionary, and language and translation instruments should not obtainable.
39. You can’t begin a Phrase On-line doc from a big choice of professionally designed templates, like those within the desktop model.
40. Workplace add-ins solely work within the Phrase desktop app and should not obtainable in Phrase On-line.

Excel On-line Limitations

In accordance with Microsoft, as of June 26, 2017, the next limitations apply to Excel On-line. Please word that this isn’t a whole record. Options that aren’t supported in Excel On-line are supported in Excel desktop app.

1. Conditional formatting can’t be utilized.
2. You can’t apply knowledge validation to cells.
3. Solely a restricted variety of add-ins can be found.
4. Superior chart options should not supported.
5. You can’t create exterior knowledge connections.
6. Freeze panes characteristic will not be obtainable.
7. Superior evaluation views, resembling Energy Pivot and Energy View should not obtainable.
8. Superior components instruments, resembling 3D reference type and array components should not supported.
9. You need to use most of Excel’s greater than 400 worksheet features in formulation, however not all.
10. Posting to social community will not be supported and you can’t current on-line.
11. Discover and Exchange characteristic will not be obtainable.
12. You can’t shield your workbooks with passwords.
13. You can’t create an IRM-protected spreadsheet.
14. Shows which might be protected with IRM can’t be edited.
15. Offline viewing and authoring of paperwork will not be supported as a result of Workplace On-line requires entry to the Web.
16. Energy Pivot knowledge fashions can’t be created, however you may view Energy Pivot tables and charts.
17. You can’t create Energy View, however you may work together with Energy View sheets in a workbook.
18. Really useful chart creation and enhancing with formatting controls will not be obtainable.
19. Creation or modification of 3D charts will not be supported.
20. Evaluation instruments resembling Objective Search, Information Tables, Solver, and Collection, should not obtainable.
21. You can’t create or edit slicers, however you may view them in your worksheets and filter your knowledge by clicking the slicer buttons.
22. Pasting textual content copied from exterior Excel On-line is inserted as plain textual content. Due to this fact, you’ll lose all formatting, resembling shade, daring, italics, and many others.
23. You can’t examine variations of a workbook, analyze a workbook for issues or inconsistencies, or see hyperlinks between workbook and worksheets.
24. You can’t create macros with VBA in Excel On-line, however you may open and edit VBA-enabled spreadsheets with out eradicating (or corrupting) the VBA contained within the file.

PowerPoint On-line Limitations

In accordance with Microsoft, as of June 1, 2017, the next limitations apply to PowerPoint On-line. Please word that this isn’t a whole record. Options that aren’t supported in PowerPoint On-line are supported in PowerPoint desktop app.

1. Solely eight transitions and 37 animations are supported. Further transitions and animations that aren’t supported in PowerPoint On-line are preserved however can’t be modified.
2. Animations can’t be created.
3. Slide present can play animations, however solely Fade and Wipe transitions between slides are supported.
4. Headers and footers can’t be inserted, edited, or deleted, however will show in the event that they exist in a PowerPoint presentation.
5. Superior design options, such creating slide masters and modifying layouts should not obtainable.
6. Wealthy formatting will not be supported, resembling extra colours, gradients, eyedropper, results, and kinds.
7. Restricted built-in themes can be found. Themes that aren’t supported are preserved if open in an current doc, however they can’t be modified.
8. Add-ins should not supported, aside from the content material add-ins for Workplace which combine Internet-based options.
9. PowerPoint On-line can not broadcast a slide present to a distant viewers by PowerPoint On-line with out the PowerPoint Desktop app.
10. Date and slide numbers can’t be inserted, edited, or deleted, however will show in the event that they exist in a PowerPoint presentation.
11. Bookmarks can’t be edited however will work in the event that they exist in a presentation.
12. Slideshow should not be greater than 100 MB.
13. You can’t create screenshots.
14. Making use of results to photos will not be obtainable, however you may insert photos out of your pc or from Internet.
15. Offline viewing and authoring of displays will not be supported as a result of Workplace On-line requires entry to the Web.
16. Slide sorter view will not be obtainable. Slide sorter provides you a view of your slides in thumbnail type making it simple to type and manage the slides.
17. You can’t edit or insert an Excel chart in a presentation, however you may view it when you open an current presentation that comprises it.
18. You can’t current on-line by Skype for Enterprise or the Workplace Presentation Service.
19. Presenters view of the behind-the-scenes management of the presentation stream, notes, annotations, and zooming instruments will not be obtainable.
20. Audio and video recordsdata can’t be inserted, aside from YouTube movies might be inserted as a result of they’re Internet-based.
21. Superior reviewer options, resembling merge conflicts and examine displays should not obtainable.
22. A customized dictionary for spell-checking will not be supported.
23. Thesaurus will not be obtainable.
24. Translation will not be supported.
25. You possibly can’t open a password protected presentation.
26. Shows which might be protected with IRM can’t be edited.
27. You can’t create an IRM-protected presentation.
28. Digitally signed displays can’t be opened.
29. Superior desk features, resembling merging and splitting cells should not supported.
30. There isn’t a Save As command to avoid wasting a presentation with a distinct identify.
31. Though you need to use Undo characteristic a limiteless variety of occasions inside a session, if the session occasions out otherwise you swap to Studying View for greater than 30 seconds, the Undo historical past is reset.
32. There isn’t a Save command which generally is a massive downside. As a result of your work is saved each time you make a change, you may’t discard your modifications and depart the doc because it was earlier than.
33. Phrase Artwork and charts can’t be inserted in a presentation, however they’re displayed in the event that they exist.
34. You can’t paste photos in PowerPoint On-line from different packages or displays exterior of PowerPoint On-line. You possibly can solely copy photos from the Internet and paste it right into a PowerPoint On-line slide.

OneNote On-line Limitations

In accordance with Microsoft, as of Might 11, 2016 the next limitations apply to OneNote On-line. Please word that this isn’t a whole record. Options that aren’t supported in OneNote On-line are supported in OneNote desktop app.

1. Pasting textual content copied from exterior OneNote On-line is inserted as plain textual content. Due to this fact, you’ll lose all formatting, resembling shade, daring, italics, and many others.
2. Add-ins should not supported, aside from the content material add-ins for Workplace which combine Internet-based options.
3. Audio notes recording will not be supported.
4. You can’t document video notes.
5. You can’t play audio or video media recordsdata.
6. If audio and video recordsdata exist in a presentation, you can’t obtain to your pc to play them.
7. You can’t clip what you see in your display screen.
8. You can’t ship a Internet web page or a whole doc to a pocket book part.
9. Fast Notes which might be robotically saved and filed as a part of your pocket book should not supported.
10. Embedding Excel spreadsheets or Visio drawings will not be supported.
11. Offline viewing and authoring of notebooks will not be supported as a result of Workplace On-line requires entry to the Web.
12. The power to jot down math equations and calculate them immediately will not be supported.
13. Picture optical character recognition (OCR) will not be supported. OCR interprets pictures of textual content, resembling scanned paperwork, into precise textual content characters.
14. In OneDrive, OneNote On-line equations are displayed as placeholders.  You can’t choose and delete these placeholders.
15. Shapes are hidden in OneNote in SharePoint.
16. Equations are displayed as placeholders in OneNote in SharePoint. You possibly can choose and edit them, however you can’t insert or edit them.
17. There isn’t a means to hyperlink note-taking recordsdata and hyperlinks to recordsdata are hidden.
18. Superior desk options, resembling changing a desk to an Excel spreadsheet or cell shading, header rows, and knowledge sorting inside desk cells should not supported.
19. Instructions to combine with Microsoft Outlook, resembling E mail web page, Outlook duties, or assembly particulars should not supported.
20. There’s not assist for superior image options, resembling display screen clipping, scanned pictures, or on-line photos.
21. Superior administration options, resembling part re-ordering, creating and deleting part teams, and drag and drop web page submitting will not be obtainable.
22. You can’t create or edit IRM-protected notebooks.
23. Notebooks encrypted with passwords can’t be opened.
24. You can’t encrypt a pocket book with password.
25. You can’t Undo transferring or deleting of pages, however you may Undo infinite variety of actions per web page throughout an enhancing session.
26. Superior search options, resembling looking by tag, title, by writer/date, and audio file should not obtainable.
27. There isn’t a assist for templates so you may’t use a template as a web page design that may be utilized to new pages in your pocket book to provide them an interesting background, a extra uniform look, or a constant structure.

Now you recognize why I mentioned that the Workplace On-line variations should not provided as a alternative for the full-featured desktop Workplace purposes, they’re solely provided so customers can shortly learn an Workplace doc on-line or make some minor modifications to the appliance.

Obtain a PDF model of this doc for offline studying.