Refresh a Locally Saved Connected Excel File

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. 


    • Related Articles

    • 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 ...

    • Introduction to Connected Excel

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

    • 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.  ...

    • Unblock Excel Files Containing Macros

      Note: Some users are experiencing blocked Macros in Excel. If you receive that message, please follow the instructions below or via this link: Unblock a File with Macros In most cases you can unblock macros by modifying the properties of the file as ...

    • 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 ...