SolveXia will perform your calculations in the exact way that it is currently performed, using your Excel and Access files. For example, when you configure a step in SolveXia to update a VLOOKUP() formula in your Excel file. SolveXia will:
- Update the formula IN your upload version of the Excel file; then
- Re-calculate your Excel file
The actions performed in SolveXia are no different to what would occur manually on your desktop, however they are now completed without the need for manual intervention (e.g. updating the formula in the spreadsheet). Furthermore, the previously manual actions are performed in a secure, centralised environment and are automatically documented with a full history of changes made to your files.