Upgrade Workbook
Workbooks that have been created in V4.x of GL Wand will need to be converted to support the architecture within V21.x. Workbooks can typically be converted manually with little effort, as it is only the GL Wand formulas that must be re-created. All non-GL Wand Excel formulas and formatting can remain as is. If your volume of GL Wand workbooks is large, you can also utilize an automated conversion tool that can be downloaded here. After downloading, please follow the steps below to convert your workbooks.
1. Right-click on the downloaded GLW4 Conversion Tool and click Properties
2. Tick the box to “Unblock” the add-in
3. Click Apply
4. Click OK
5. Double-click on the GLW4 Conversion Tool to open
6. Ensure that the V4.x add-in (Wands SAP) is active/ticked, but not logged in by navigating to File –> Options –> Add-ins –> Go
7. Open workbook to be converted
8. Click Convert GLW4 Workbook on the GLW4 Converter tab
9. A copied workbook with converted functions will be created in the same folder location as the source workbook with “_5” appended to the name
10. Repeat Steps 6-8 above for as many workbooks as you intend to convert, then proceed to Step 10
11. Toggle from V4.x to V21.x to test the converted workbook
Note: Nested functions within a GL Wand function are not supported for the conversion process. As a workaround, replace all the nested formulas with a placeholder before conversion, and then replace all the placeholders with the nested formula after the conversion