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
1) Download the addon from GitHub here and store it to a folder of your choice.
2) Open Excel, click on the main menu (or
File in newer Excel versions) then
Add-Ins --> Excel-Addins:
Browse and select the .xlam file, select it with a check-box and click
4) A new Ribbon called
Valispace should have appeared in the top main menu.
5) 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 -->
Trust Center Settings... -->
Trusted Locations -->
Add new location... -->
Browse and add the folder where you stored the Addon.
6) To setup Valispace, in the new
ValiSpace Ribbon, select
Settings and insert your deployment's URL (e.g.
https://yourdeployment.valispace.com), your username and password and confirm with