"UPDATE EXCEL" from the RESULTS window

[OlivierD]

Hi,
Struggling to work out how to use the "update excel" tab (and facility) from the Results panel.
Could you point me where to find how it works in VEDA2.0?

It was very useful in the old VEDA_BE and was working fine (if not slowly sometime).
I would like if possible to use it in VEDA2.0 - but couldn't make it working.

Thanks,
Olivier

[ggian]

Hi Oliver,

"Update Excel" will not work directly with excel files which you have used with VEDA-BE.
You need to create one excel sheet for each table you want to update following the format required by Veda2.0. The easiest way to do this is to do a batch export to excel for all the tables you would like to update regularly, clear the numbers, and use this as a master copy for updating it.
"Batch update" as it was used in VEDA-BE does not work in Veda2.0. You need to create a copy of the "master" excel with a different name each time you want to update the tables.
Then you need to: 1. Set a global filter for the scenario you want to use for updating the excel, 2. Click on Update Excel/All tables 3. Select the excel file which you want to update.

Test this with one table  just to make sure that the process is working.

Alternatively you can export the tables using batch export and use sumifs in excel to create a new set of reporting tables. But this means creating everything from scratch. This can also work with the Reports functions (I think that this is only available with the advanced license), were you can create reports, export tables in csv format and then create an excel with final tables using sumifs (see this webinar on how to use Reports https://www.youtube.com/watch?v=ri6asoxXcRg ).

I hope this helps.
George