Connected Excel Requirements

Connected Excel Requirements

Requirements

TABS uses Azure Analysis Services to host our data models and enable real-time analytics. If you would like to interact with our live data using Connected Excel, you must have the correct Microsoft Client Library installed on your computer. Installing this library enables Excel to connect to our Azure Analysis Services model(s). It is a standard Excel library and is not customized for TABS in any way.


Check Your Excel Version
The minimum Excel version that will work Analysis Services is Excel is 2016. Check the Excel/Office version by navigating to File > Account. Check Product Information in the top right hand corner.  If you have Microsoft O365 or Excel 2016 or higher your Excel version should be compatible as long as the Client Libraries below have been updated. 

Download the Microsoft Client Libraries

Install the client libraries from Microsoft from the Microsoft docs page, here.  Microsoft keeps this page updated so that you can always find the most recent version. Install both 64-bit (amdx64) and 32-bit (x86) versions. The image below shows the MSOLAP libraries that need to be installed. 




 

 


    • Related Articles

    • Introduction to Connected Excel

      Please check out this video overview of the Connected Excel experience.  

    • Refresh a Locally Saved Connected Excel File

      To refresh a locally saved Connected Excel file to the latest refresh date, open the file and go to the Data tab in the ribbon. Click Refresh All. The document will refresh to the most recent refresh date. 

    • Accessing Excel Files in the Portal and Editing Steps

      Steps to Download Content and Sign into Connected Excel Make sure your version of Excel meets the requirements, here.  Log into the Portal and click the Files tile in the landing page.  Hover over an Excel file to download and click it to download.  ...

    • Excel Authentication Error

      Issue When you open Excel a TABS connected Excel report and attempt to sign in using your credentials, an authentication error occurs. Examples of errors: AADSTS50011: The reply URL specified in the request does not match the reply URLs configured ...

    • Issues Logging into the TABS Web Portal or Excel

      Issue: When you try to log into the portal or Excel, you get an error saying the selected account does not exist. Solution: NOTE: If your account isn't connected to Windows and you have to enter your email address at the start, these directions won't ...