AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

Try Excel Online For Free

August 18, 2015 by Tim Rodman

The Current Excel Online Problem

Three weeks ago we looked at using Excel Online to deliver your awesome Excel reports to people without them having to know that you made it in Excel.

However, there currently is a problem with Excel Online. The problem is that there are actually different versions of Excel Online. There is a Free version, there is a Business version, and there is an Enterprise version. For more details, checkout this post by Mike Alexander (click here).

I personally do not understand all the differences between the versions or even if these are indeed all the versions of Excel Online. There might be others that I am not even aware of yet. This is the downside of the Microsoft BI strategy at this time. It can be tricky to navigate all of the different options.

So far I have only been able to get Acumatica OData to work with the Enterprise version of Excel Online.

If I’m not using the Enterprise version of Excel Online, then I get the following error when I try to refresh: “This workbook contains external data connections or BI features that are not supported”. For more information on this error, click here.

Excel Online Error: This workbook contains external data connections or BI features that are not supported

If you get this error, it means that you don’t have the right version of Excel Online.

The Good News

Office 365 has become a very popular way for companies to handle their email. And, in many cases, you may already have the Enterprise version of Excel Online available to you. If you do, you can follow the steps shown in the video from three weeks ago (click here). If you don’t, fear not, the Office 365 landscape is changing rapidly and it might not be very long until this will be available to all Office 365 users.

Microsoft is making a heavy investment in this area and I expect that things will get simpler as time goes on. For example, just last month Microsoft launched a revamped version of PowerBI.com for building dashboards and it got a lot of hype. One of the key features is that you can now embed Excel Online into your dashboards.

Check with your IT department to see if you already have an Office 365 subscription through your work. It may be that you already have one.

Try Excel Online For Free

If you don’t already have access to the right version of Excel Online through work, you can sign-up for a FREE trial version of Office 365 Enterprise through Office.com.

Adam Saxton (aka “Guy in a Cube”) from Microsoft has a great video on how to do this (click here):

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica BI, Acumatica Blog, Acumatica Excel Connector, Acumatica OData, Acumatica Reporting, Acumatica Reports in Excel, Acumatica Training, Microsoft Excel, Power BI, Power Pivot, Power Query

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Bug in processing a Purchase Requisition

    Hi @jhoannaj, I think you’ll have better luck wit...

    By Tim Rodman, 3 hours ago

  • RE: AP Void Question

    Hi @mikerosz, I think you’ll have better luck wit...

    By Tim Rodman, 3 hours ago

  • RE: Split Default Warehouses

    Hi @matthewjames, I think you’ll have better luck...

    By Tim Rodman, 3 hours ago

  • RE: Tracking Purchase Order Changes in Acumatica

    @kurtybauer Great point about the AuditHistory table si...

    By Tim Rodman, 3 hours ago

  • RE: Odata Feed in 2020 R1

    I have experienced #2 and #3, but not #1.

    By Tim Rodman, 3 hours ago

  • RE: Bug: Unable to Preview Reports on Report Designer

    I haven't used the preview feature much other than when...

    By Tim Rodman, 3 hours ago

  • RE: Payment and Application Type - Customer Refund

    Hi @tlynn, I think you’ll have better luck with t...

    By Tim Rodman, 3 hours ago

  • RE: Amend a SO with a status of "Shipping"

    I would first try to use Automation steps and adding th...

    By Ryan Brown, 18 hours ago

  • RE: Timecard reports/queries

    @tricia-carlson Ah, good point. I think you'd need to m...

    By Tim Rodman, 1 day ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.