New Microsoft Office Excel on iPad Native App

Posted by  Jen Underwood   in  ,      7 months ago     7296 Views     Comments Off  

Excel Native App iPad

Today exciting and long-awaited news of Microsoft Office native apps for Apple iPad was finally released along with the availability of Microsoft Office in the iPad app store. I won’t reiterate the same information that you can read in the Microsoft blog but I will highlight a few key points and of course talk about mobile BI with this new flavor of Excel.

Starting today, you can download Word, Excel and PowerPoint for iPad from the Apple iTunes App Store. They have also released Office Mobile for iPhone in the App Store and even Android phones in Google Play.  Read only versions of  Office Mobile apps are free. To get the full editing and creation experience, you will need an Office 365 subscription. Finally going true cross-platform in the mobile world illustrates Microsoft’s commitment to the recent “mobile first and cloud first strategy”.

For my readers that have followed me over the past few years, you know that I am a big fan of mobile BI and the competitive advantage proactive information on the go brings to any organization.  Just look at my iPad – it is jam packed with many BI vendor mobile BI apps. I simply can’t help myself when it comes to things that I enjoy. In 2011 and 2012, I shared technical details around Office 365 Excel and Visio browser-based mobile BI capabilities at various industry conferences. Starting with the Office 365/Office 2013 launch in November 2012 touch, browser-based, mobile BI with Excel 2013 documents hosted in the Office 365 cloud did improve tremendously allowing for editing of pivot table and chart reports, interactive drill down, slice & dice via quick explore features and so on. I have some of my old Office 365 Excel mobile BI demos of these features in my YouTube video gallery and in the Microsoft TechEd Session on mobile BI.

Excel Mobile BI options

Playing with the brand new Microsoft Office Excel native apps on Apple iPad and iPhone tonight was promising but a bit disappointing right now for a BI fan. Here are a few of my tests using the same mobile BI demo files from 2012. Bottom line, the Office 365 browser-based mobile BI on iPad and other mobile device platforms is far better than the new Office Mobile Excel native apps released today. My Office Mobile Excel native iPad app only lets me see static charts and limited filtering today. Going to the iPhone, I have even less capability available. I can only see my unformatted report with no filtering. A few of the noted mobile BI features that are currently missing in the new Office Mobile Excel native apps include but are not limited to the following:

– Power View sheets are not supported
– Slicers are not supported, blank cells are rendered
– Pivot tables and charts are not fully supported
– Excel tables with filters render in the native mobile Excel iPad app but not on iPhone
– Conditional formatting renders in the native mobile Excel iPad app but not on iPhone
– Background images render in the native mobile Excel iPad app but not on iPhone
– Hyperlinks work on the native mobile Excel iPad …unsure if these work on iPhone
– Office Web Apps are not supported

Here are a few more images from my initial Office Mobile Excel testing tonight.  If you click on any of the images, you should see the larger version to get better clarity on the current Excel flavor differences.

More Excel Compares

Excel free rendering on OneDrive

Even More Excel Compares

Excel Pivot Error

Microsoft’s claim of Office documents looking better than ever on iPad is true! Excel sparklines, charts and graphics do look totally gorgeous. I noticed this quiet change happening while working in the Power BI TAP pre-release program earlier last year. These little presentation improvements do make a difference.  First impressions and application user interface designs can make or break the success of an application.  Ugly applications that are functionally powerful often fail to be adopted due to user perceptions that the application might be inferior.

Another thing I tested was sharing content with others via OneDrive (formerly SkyDrive) and my Office 365 Power BI Impact Analytix Team Site. It was easy and just worked. I did think it was interesting that my test Excel file renders in OneDrive differently than it does in the web browser and in the native Excel app for iPad…so there must be yet another flavor of Excel rendering in OneDrive.

Office Native Apps on iPad

All in all, the new Office Mobile native apps for iOS and Android are a huge deal. Since they bring additional revenue streams for Microsoft, they will continue to get development love and improve over time. As for the highly anticipated Office 365 Power BI native mobile app for iPad…still crickets and waiting out here. I imagine many of the weaknesses that I cited above for the Office Mobile Excel native apps will not exist in the Power BI native mobile apps when they finally get released. Now you just have to keep track of what mobile BI Excel features work with what flavor of mobile Excel delivery – OneDrive, browser-based Excel, Excel native app and the Power BI native mobile app. Also take note of what mobile BI Excel delivery methods have licensing costs and what options are free. You do get 5 device licenses with Office 365 subscriptions.


Jen is a Microsoft Sr. Program Manager of Business Intelligence & Analytics. She works with external groups, customers, channel partners, MVPs, BI professionals and application developers to better connect the outside world to engineering. Previously she was a Microsoft Business Intelligence Sr. Technical Product Manager for offerings spanning across Microsoft SQL Server, Excel and SharePoint. She also held roles as an Enterprise Data Platform Specialist and a Business Intelligence Consultant for Big 4 Systems Integration firms. Throughout most of her ~20 year career she has been researching, designing and implementing data warehousing, business intelligence and predictive analytics solutions across a variety of open source, niche and enterprise vendor landscapes including Microsoft, Oracle, IBM, and SAP. Jen is quite active in the global technical community as a presenter, author, blogger and volunteer. Jen was previously honored with a Boulder BI Brain Trust (BBBT) advisory membership, a 2013 Tableau Zen Master (MVP) award and a Dun & Bradstreet MVP. She writes articles for TechTarget's BeyeNetwork, SQL Server Pro magazine and other industry media channels. Jen holds a Bachelor of Business Administration degree from the University of Wisconsin, Milwaukee and a post graduate certificate in Computer Science - Data Mining from the University of California, San Diego.


  1.   November 11, 2014, 1:11 PM

    Hi Jen. I’ve been trying to embed an Excel 2013 workbook in my public facing website in SharePoint Online per your instructions above (file stored in my personal OneDrive account). My workbook is attached to a Power Pivot data model. The slicers don’t work. I get an error message that says something to the effect that the workbook contains BI features that are not supported.

    I’m thinking that your workbook is not attached to a Power Pivot data model and mine is, so that’s the problem. I’ve been working with Microsoft support on this issue. First they had me try using an Excel Web Access Web Part but this won’t work for anonymous users (a license is required). Then they had me try the Page Viewer web part but that won’t work on a public facing website.

    I think that Microsoft should come up with something that works. I don’t know why they require a license for the Excel Web Access Web Part because this would be a great tool for marketing/promoting the functionality of Excel (I wanted to demo a market basket analysis solution) to prospective clients. It sounds like you have been pushing for this type of functionality. Keep pushing. :)

    Thank you.


    Arthur Jenkins

    •   November 13, 2014, 3:56 PM

      I have shared that feedback with the product team. Keep an eye out for news in the upcoming 2 months. In the meantime, you are right. Excel docs with PowerPivot models are not supported with the cool embedding/share feature at the moment.

      •   November 14, 2014, 12:51 AM

        Your comment is awaiting moderation.

        Hi Jen. Thank you for your reply. I’ll keep my eyes open.


        Arthur Jenkins

  2.   October 21, 2014, 3:29 PM

    DOMO failed to deliver as promised. They sold a seamless way for managers to get real time reports. The DOMO QuickBooks “Connector” was not seamless. It did not operate as Domo stated it would. They blamed the issue on QuickBooks. DOMO takes months to troubleshoot and solve issues.

Leave a Reply

You can use these tags:   <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>