You may come across an issue where when re-calculating a worksheet with XRL it errors like below.


How to fix:

  1. Navigate to \\solar\it tools$\Software\Infor Q&A\Invalid Query fix and copy the folder called "Ps-G-3H".
  2. Paste the copied folder "Ps-G-3H" on the affected machine to the location "C:\Program Files (x86)\Infor\Query and Analysis\Settings\LsAlchemy"

  3. Restart Excel and when running the re-calculation it should not error.