Velixo NX minimum requirements and considerations

Modified on Wed, 20 Sep 2023 at 03:41 PM

Overview

Velixo NX is the next generation of Velixo reporting - built using the latest extensibility technologies available in current versions of Excel 365 or Excel 2021 for Mac*, Excel Online, and Excel for Windows.

Most requirements echo those for Microsoft Excel.

Minimum System and other Requirements

OS	Windows 11, Windows 10 SAC, Windows 8.1, Windows Server 2019 or Windows Server 2016, Mac OS Monterey (v12.1) or higher
Processor	Intel or AMD processor 1.6 GHz or faster (2-core)
RAM	4GB or more (2GB for 32-bit)
Hard Disk	4GB of available disk space
Excel	Excel 365 (recent version) or Excel 2021
MS Account	A Microsoft Account is required to be able to install and use Velixo NX

Note: Microsoft added support for function-based add-ins *after* the release of Excel 2019.  Subscription (Excel 365) users received that update automatically.  For installations which are *not* based on Excel 365, Excel for Mac 2021 or higher is needed.

Velixo NX Considerations

Velixo NX is the next generation of Velixo reporting - built using the latest extensibility technologies available in latest versions of Excel 365 on Mac and on the web.

Each platform (Mac, Online, and Windows) has its own advantages. There are also certain limitations to using Velixo NX with either Excel for Mac or Excel Online.

Unsupported Velixo Features

Currently, there are two specific Velixo features that are not available in Velixo NX:

Generic Writeback
Distribution Lists

The Velixo team is constantly working on adding new capabilities to Velixo NX.

Generic Inquiry Limitations

Both Excel for Mac and Excel Online use web browsers for displaying data (Excel for Mac uses the Safari browser).

With those products, there is a 5MB limit to the amount of data that can be returned/displayed by a single function. While the number of rows that can be displayed by a Velixo GI() function is also dependent upon the number of columns returned, we have found that this limit translates to somewhere between 25000 and 50000 rows.

VBA Limitations

With Excel for Mac, VBA only supports accessing basic Excel functionality. It is not currently possible to access the Velixo VBA functions when using Excel for Mac.

Speed Comparison

The time necessary to run a report will vary depending on the platform being used.

While Velixo is always striving to enhance the functionality and performance of all our products, in order to help our customers understand what to expect from each platform, here is a general comparison of the time needed to run the same report using Excel for Windows (with both Velixo Classic and Velixo NX), Excel Online (using Chrome and Velixo NX), and Excel for Mac (using Velixo NX and Excel for Mac's integration with Safari).

(This comparison assumes all other aspects being equal - report, computer speed, etc.)

Applies to:

Velixo Classic
Velixo NX
Sage Intacct
Acumatica, MYOB Advanced, Cegid XRP Flex

The {FUNCTIONNAME} returns ......

Important: ...

TABLE OF CONTENTS

Syntax
Parameters
Examples
- Example 1

Syntax

{FUNCTIONNAME}(Connection, ...)

Parameters

The {FUNCTIONNAME} function uses the following parameters:

Parameter	Required/Optional	Description
Connection	Required	The name of the connection as configured in the Connection Manager
...

* see Filtering Techniques for Velixo Functions

Examples

Example 1

{FUNCTIONNAME(Connection, ...)

Description

Returns .....

Result

(cell references have been used for some parameters in this example)