If all cells are returning #VALUE, please try re-installing the add-in. If only some cells are returning #VALUE, the errors result when Excel cannot interpret the data in your formula.  Be sure that you are using cell references (ex. B1,C3) for your formula, NOT actual values (ex. 4000, 01/10/2020). Another common reason for #VALUE errors is from misspelled  Xero Tracking Categories or misspelled QBO parameters such as Class, Customer, that are referenced by =SCOTT functions.