The MS Excel Addon lets you exchange data bi-directionally between your Excel Worksheet and your Valispace deployment.
By clicking on
Add Vali in the ValiSpace Ribbon, you can select a Vali which you would like to reference in the cell which is selected. It will then be inserted.
By clicking on
Refresh Valis in the ValiSpace Ribbon, all of your cells which reference (Pull) Valis in your workbook will be updated to the newest value from your Valispace Deployment.
Select a cell in your workbook, for which you want to recurrently upload its value to your Valispace deployment. Then click
Add Push Vali to connect it to a Vali which you can select from the list.
Whenever you click
Push Valis in the ValiSpace Ribbon, all Push Valis will be pushed to your Valispace deployment. You will receive a message with all performed updates.
Download and installation
Download the latest version of the addon from the releases page in Github and store it to a folder of your choice.
Open Excel, click on the main menu (or
Filein newer Excel versions) then
Browseand select the .xlam file, select it with a check-box and click
A new Ribbon called
Valispaceshould have appeared in the top main menu.
To prevent the need to re-do the same steps every time you start Excel, you will have to add the folder containing the Add-In to your "Trusted File Locations". To do this, click on
Trust Center Settings...-->
Add new location...–
Browseand add the folder where you stored the Addon.
To setup Valispace, in the new
Settingsand insert your deployment's URL with https://(e.g.
https://yourdeployment.valispace.com), your username and password and confirm with