This page features the technical specifications and change log for Quick Steps.
Contents
Technical specifications
Compatibility
- Windows PC only (no support for Mac)
- Excel Desktop 2016 onwards, including Excel 365 (no support for Excel Online)
Licensing
Users may use the Quick Steps functions on unlimited devices, may make unlimited copies, and may use the functions in solutions shared with others.
Users may not share the entire function library. Functions can only be shared with others where relevant to a specific solution.
Usage of the add-in is restricted to the single user who acquired the license through either their membership or a one-off purchase.
Please contact customer support (https://exceloffthegrid.com/customer-support) to discuss
- team and site licensing options
- Selling the Quick Steps library or add-in as part of another service or product
Change log
Current Version: 1.0004
| Version | Release Date | Changes |
| 1.0004 | 2025-03-24 | Depreciated: [1] Power Query Quick Steps Add-in removed and replaced with Function Vault add-in (which incorporates LAMBDA and Power Query functions). Enhancements / Bug Fixes: [1] Tags added around description names to import descriptions into Function Vault |
| 1.0003 | 2024-10-17 | Enhancements / Bug Fixes: [1] fxTextRemoveSpaces – coded cleaned and comments removed [2] fxApproximateMatch – some connectors (e.g. PDFs) did not provide correct result. PQ optimized code in background and changed pre-existing sort order. Result is now forced to correct order. [3] fxGroupRowUnpivot – function signature changed to match fxGroupColumnUnpivot, making it usable in more scenarios. |
| 1.0002 | 2024-05-08 | New Features: [1] New functions added: – fxGroupColumnUnpivot – fxGroupRowUnpivot Enhancements / Bug Fixes: [1] fxFlattenHeaderRows now functions correctly with promoted headers (e.g. where column headers are not “Column1,Column2,Column3” etc). [2] Speed enhancements for: – fxGroupRunningTotal – fxPreviousRow – fxRemoveNullColumns – fxRunningTotal – fxTextRemoveSpaces – fxRepeatValueToNull |
| 1.0001 | 2024-02-12 | New Features: [1] Info button added to provide version number [2] New functions added: – fxDeleteNullMoveLeft – fxRepeatValueToNull – fxRowNumberByGroup – fxFilesInSharePointFolder [3] Function argument details are now included within the first section of code to increase visibility within the code preview box (appears when hovering the mouse over the function name in the formula bar). Enhancements / Bug Fixes: [1] Added process to find ribbon object, even if errors occur. [2] Speed improvements to: – fxRenameColumnsByPosition – fxGetNameParameter – fxGetTableParameter [3] Displays error if there is no active workbook. |
| 1.0000 [Beta] | 2023-09-20 | First version |