The DLM Excel-Addin has an in-built cache with 2 functions:
Once the source has been selected, you will be able to: To start using DLM Excel-Addin, you first need to select the source of data: Whenever you are authenticated, the access token is used for all data retrievals as well as for all data saving for the relevant data sources. the list of data sources (data spaces) for which you have default or advanced permissions.When returning from the web authentication to Excel, the Excel-addin ribbon will display a “Log out” button with a dropdown menu showing:
#Manage excel add ins update
Once successfully authenticated, the Excel-Addin will automatically proceed executing the currently requested action on the data source as well as regularly and automatically update the access token in order to always have a currently valid token until the Excel workbook for which the identity was required is closed. Note that this is only necessary for internal data sources and/or organisations having an authentication service put in place. When extracting data for a new table, changing a selection, refreshing a table or saving data related to an internal data source, and if you haven’t authenticated for that data source within the current Excel session yet, then you will be redirected to your default web browser in order to provide your login credentials to the (optional) configured third-party identity provider within your organisation. Stat DLM Excel-Addin will appear in your Excel ribbon. editing/adding and uploading data to internal data sources (provided the user has sufficient permissions).
authenticating for access-restricted internal.! This version is ONLY for demo purposes, to be executed only in a non-trusted environment such as a personal computer or outside your organisation/company’s network.Īlso included in the zipped package is a short text procedure for easing the installation. This installation package has already be signed with a self-signed certificate, and can immediately be used for an isolated, local installation.
#Manage excel add ins upgrade
Whenever the installation package on the shared folder is updated (and re-signed), the ClickOnce technology will automatically upgrade all local user installations when they open Excel the next time.Ī ready-made (.zip) demo version can also be downloaded from here. to reference specific SDMX data sources or update the application title), to re-sign the installation package with your organisation’s own certificate, and allow users running locally the installation. The installation files are accessible from here along with more information about deployment, set up and configuration.Ī best practice is to store the files on a shared network folder, update the configuration (e.g. The DLM Excel-Addin is delivered as a ClickOnce application and is deployed using the common procedure for deployment of ClickOnce applications. It gives access in Excel to in-progress or published data, from internal or external SDMX data sources. Stat DLM Excel-Addin is a powerful Excel facilitator of data editing and sharing.