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 | 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
{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
<screenshot>
(cell references have been used for some parameters in this example)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article