Upgrade Workbook
Workbooks that have been created in V4.x of GL Wand will need to be converted to support the architecture within V5.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
This is a very limited conversion tool designed to handle non-nested, single formula per cell GL Wand functions
6. Open workbook to be converted
7. Click Convert GLW4 Workbook on the GLW4 Converter tab
8. A copied workbook with converted functions will be created in the same folder location as the source workbook with “_5” appended to the name
9. Repeat Steps 6-8 above for as many workbooks as you intend to convert, then proceed to Step 10
10. Toggle from V4.x to V5.x to test the converted workbook
Duplicate formulas per cell will have the cell background colored red and the number of error cells will pop up in a message at the end of the process
It is recommended, however not required, to locate any cells that use List of Values (LOV) tags, and click Create LOV to overwrite the V4.x tags with V5.x tags