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 AccountA 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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article