Prerequisites

XLCubed Excel Edition


XLCubed Excel Edition requires several packages installed in order to operate correctly. These will be downloaded and installed automatically when you run the XLCubed Excel Edition Setup program.

If access to the internet is unavailable, the packages can be manually installed in this order prior to installation.

  • Microsoft .NET Framework 4.5.2
  • Microsoft Visual C++ 2010 SP1 Redistributable (x86) or (x64) Note: install the version appropriate for the Excel architecture you are using
  • Microsoft Core XML Services (MSXML) 6.0 (x86) or (x64)
  • Microsoft SQL Server 2000 PivotTable Services (Analysis Services 8.0 OLEDB Provider, also known as PTS) (x86 only)
  • Microsoft SQL Server 2005 Analysis Services 9.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2008 Analysis Services 10.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2012 Analysis Services 11.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2014 Analysis Services 12.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2012 Analysis Services 11.0 ADOMD.NET Provider (x86) or (x64)
  • Microsoft Access Database Engine 2010 (x86) or (x64) Note: install the version appropriate for the Excel architecture you are using


And to support Azure connections, these additional packages should be installed:

  • Microsoft SQL Server 2016 Analysis Services 13.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2016 Analysis Services 13.0 ADOMD.NET Provider (x86) or (x64)


Supported environments

Excel Edition:

  • Windows 10, 8, 7, Vista SP2
  • Office 365, 2016, 2013, 2010, 2007
  • Microsoft .NET Framework v4.5.2

Supported Versions of SQL Server:

  • SQL Server 2000 Standard or higher
  • SQL Server 2005 Standard or higher
  • SQL Server 2008 Standard or higher
  • SQL Server 2008R2 Standard or higher
  • SQL Server 2012 Standard or higher
  • SQL Server 2014 Standard or higher
  • SQL Server 2016 Standard or higher
  • SQL Server 2017 Standard or higher

Other versions

  • See here for other XLCubed Excel Edition versions.

XLCubed Web Edition


Required Windows Components

Before installation, XLCubed Web Edition requires several Windows components to be installed. This can be found in Server Roles for Windows Server operating systems, or in Windows Features for non-server versions.

  • Static Content
  • .NET Extensibility
  • ASP.NET
  • ISAPI Extensions
  • ISAPI Filters
  • HTTP-Activation
    • Control Panel / Programs and Features / Turn Windows features on or off / .Net Framework 3.5 / Windows Communication Foundation HTTP Activation
    • Control Panel / Programs and Features / Turn Windows features on or off / .Net Framework 4.5 Advanced Services / WCF Services / HTTP Activation
  • Any Security components that will be required to connect to the data sources, usually Basic Authentication or Windows Authentication

Additional Prerequisites

XLCubed Web Edition requires several packages installed in order to operate correctly. These will be downloaded and installed automatically when you run the XLCubed Web Edition Setup program.

If access to the internet is unavailable, the packages can be manually installed in this order prior to installation.

  • Microsoft .NET Framework 4.5.2
  • Microsoft Visual C++ 2010 SP1 Redistributable (x86) or (x64) Note: install the version appropriate for the application pool architecture you are using
  • Microsoft Core XML Services (MSXML) 6.0 (x86) or (x64)
  • Microsoft SQL Server 2000 PivotTable Services (Analysis Services 8.0 OLEDB Provider, also known as PTS) (x86 only)
  • Microsoft SQL Server 2005 Analysis Services 9.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2008 Analysis Services 10.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2012 Analysis Services 11.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2014 Analysis Services 12.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2012 Analysis Services 11.0 ADOMD.NET Provider (x86) or (x64)
  • Microsoft Access Database Engine 2010 (x86) or (x64) Note: install the version appropriate for the application pool architecture you are using


Additionally, to set up the SQL Repository functionality, this additional package should be installed, together with its prerequisites, SQL Native Client and CLR Types for SQL Server (all on the same page):


And to support Azure connections and Pivot View on 64bit machines, these additional packages should be installed:

  • Microsoft SQL Server 2016 Analysis Services 13.0 OLEDB Provider (x86) or (x64)
  • Microsoft SQL Server 2016 Analysis Services 13.0 ADOMD.NET Provider (x86) or (x64)


Supported environments

Web Server:

  • Windows Server 2008 SP2 or above
  • Internet Information Services 7.0 or above
  • Microsoft .NET Framework v4.5.2

Web Client:

  • Internet Explorer 9.0 or higher
    • Internet Explorer must not be in "Compatibility View" mode.
  • Chrome 5.0 or higher
  • Firefox 3.6 or higher
  • Safari 5.0.6 or higher
  • Edge

Excel Edition:

  • Windows 10, 8, 7, Vista SP2
  • Office 365, 2016, 2013, 2010, 2007
  • Microsoft .NET Framework v4.5.2

Supported Versions of SQL Server:

  • SQL Server 2000 Standard or higher
  • SQL Server 2005 Standard or higher
  • SQL Server 2008 Standard or higher
  • SQL Server 2008R2 Standard or higher
  • SQL Server 2012 Standard or higher
  • SQL Server 2014 Standard or higher
  • SQL Server 2016 Standard or higher
  • SQL Server 2017 Standard or higher

Other versions

  • See here for other XLCubed Web Edition versions.