Business Intelligence for Excel 2016

Is it possible to use the Business Intelligence tools within Sage 2015 with Excel 2016?

  • Quick answer is no.
    Sage 200 2015 only supports up to Excel 2013 (32bit) for B.I.
    Sage 200 2016 supports Excel 2016 (32bit) for B.I.

    Note: If you have an office 365 subscription - you should still have the option to downgrade and download Office 2013
    Hope this helps
  • Tom, Excel 2016 APPEARS to work for 200 BI. But beware! I quickly (but *very* luckily) found "weird" errors in the data where key pieces of data were randomly missing. Viewing the same data in Office 2013 gave correct results.